Using Array formulas to pull data from one tab to another

[mobie86]

Hi Everyone,

I am using Array/Index formulas to pull specific data from one tab to another in the same workbook. I have successfully made the formulas worked in other workbooks but for some reason I can't get it to work using this data. I have attached an example of my workbook and what I am looking for.

Also, is there other ways to accomplish what I'm trying to do with macros.

Thanks,
Mildred

[martindwilson]

=IFERROR(INDEX(EI!$C$3:$W$150,SMALL(IF($C$3=EI!$K$3:$K$150,ROW(EI!$K$3:$K$150)-MIN(ROW(EI!$K$3:$K$150))+1,"NA"),ROW(EI!A1)),COLUMN(EI!A1))," ")
the bit in red was wrong

[mobie86]

Thank you! I guess I was starring at it too long.