VLOOKUP and then add an IF function

  • Thread starter Thread starter DebbieB
  • Start date Start date
D

DebbieB

On a VLOOKUP, I do not want "None" to appear when the
choice is 0. I'd rather it be blank. Do I add an IF
function after the Vlookup? I put an example in D19 that I
think I am supposed to add to the Vlookup, but it doesn't
work. What am I doing wrong?

=VLOOKUP(B19,SFT!A12:C15,2),if(c19=none,"",c19)
 
Hi Debbie,

I think this is what you're looking for:

=IF(ISNA(VLOOKUP(B19,SFT!A12:C15,2)),"",VLOOKUP(B19,SFT!
A12:C15,2))

bIFF
 
Back
Top