Help with 2 formulas together

B

Barb Reinhardt

How about putting your VLOOKUP within this

=IF(VLOOKUP()=1,VLOOKUP(),NA())

Or replace NA() with "". Just replace VLOOKUP() with your VLOOKUP formula.
 
Top