HI, I’m trying to make an excel formula that on sheet 2 ( 1 East) if an “x” is in column I on sheet 1(we’ll call “List”, it will return the value in column D on sheet 1 (“List”). If there is no data I want it to go to the next line and have no blanks on sheet 2. I’ve tried numerous times and have the if formula built, but then get blanks.

I've attached screen shots

This is my if formula: =IF(List!I11:I19=”X”,List!A11:A19,””)

When I try to use an IFERROR and SMALL with ROW formula:
=IFERROR(SMALL(IF(List!I11:I19=”X”,List!A11:A19,””) ,ROW()-2),””), I get blanks.

Please help. Thank you in advance!