Index Match: Show blank instead of #NA for no match

[cedarhill]

Excel 2003

How can I modify the following formula to show a blank instead of #NA when no match is found?

Please Login or Register  to view this content.

[daddylonglegs]

Try this version

=IF(D2="","",IF(ISNA(MATCH(Control!$H2,Master!$A$2:$A$601,0)),"",INDEX(Master!$E$2:$E$601,MATCH(Control!$H2,Master!$A$2:$A$601,0))))

[cedarhill]

Thank you very much!