I have a VLOOKUP as follows:
=IF(ISNA(VLOOKUP(A3,'[MonsterOnline_Impressions_Julye06.xls]Monster, July 2006 (2)'!$D:$H,5,0)),0,(VLOOKUP(A3,'[MonsterOnline_Impressions_Julye06.xls]Monster, July 2006 (2)'!$D:$H,5,0)))
I would like to highlight the target cell in '[MonsterOnline_Impressions_Julye06.xls]Monster, July 2006 (2)'! that is being picked up by the VLOOKUP, any color is okay
I would appreciate any help!
Thx
Sean
=IF(ISNA(VLOOKUP(A3,'[MonsterOnline_Impressions_Julye06.xls]Monster, July 2006 (2)'!$D:$H,5,0)),0,(VLOOKUP(A3,'[MonsterOnline_Impressions_Julye06.xls]Monster, July 2006 (2)'!$D:$H,5,0)))
I would like to highlight the target cell in '[MonsterOnline_Impressions_Julye06.xls]Monster, July 2006 (2)'! that is being picked up by the VLOOKUP, any color is okay
I would appreciate any help!
Thx
Sean