Lookup with multiple rows.

[danl8619]

Hi everyone,

I have been trying to auto update a table by looking up information from a table on top. However, for the top table there are multiple entries in the same column, and my look up only checks the first row and ignores the rest. My formula at this point is: =IF(ISERROR(INDEX($C$3:$H$33, MATCH("X", I$3:I$33, FALSE), 4))=TRUE, "", IF(INDEX($C$3:$H$33, MATCH("X", I$3:I$33, FALSE), 4)=0, "", INDEX($C$3:$H$33, MATCH("X", I$3:I$33, FALSE), 4))). If you can take a look at my attachment, this formula is in the cells I40:W40. Eventually, I will want to populate the entire bottom table with the same formula. Sorry if I haven't explained my problem better, but this is my first post. Please let me know if you have any questions.

[NBVC]

In I38, try:

=IF(SUMPRODUCT(($C$3:$H$33=$H38)*(I$3:I$33="X")),"X","")

copied down and across.

[danl8619]

This worked perfectly! Thanks for the help.