I want to do a vloopkup and if is not 1 make it appear blank?
B Barb Reinhardt 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.