G Guest Oct 26, 2006 #2 How about putting your VLOOKUP within this =IF(VLOOKUP()=1,VLOOKUP(),NA()) Or replace NA() with "". Just replace VLOOKUP() with your VLOOKUP formula.
How about putting your VLOOKUP within this =IF(VLOOKUP()=1,VLOOKUP(),NA()) Or replace NA() with "". Just replace VLOOKUP() with your VLOOKUP formula.