Formula that displays text if 0 found

[Yandeez]

I use a simple Vlookup that pulls the value from a column that may or may not have data in the cell. Since the Vlookup finds my search criteria (which is correct) it doesn't display an #N/A - it simply displays the number 0. I need a formula that changes that 0 to the text "No". As always, any help is greatly appreciated.

 

[Mike H..]

I use a simple Vlookup that pulls the value from a column that may or may not have data in the cell. Since the Vlookup finds my search criteria (which is correct) it doesn't display an #N/A - it simply displays the number 0. I need a formula that changes that 0 to the text "No". As always, any help is greatly appreciated.

Hi,

Try this like this

=IF(VLOOKUP(C1,A1:B20,2,FALSE)=0,"No",VLOOKUP(C1,A1:B20,2,FALSE))

 

[Somendra Misra]

Hi,

You can also use custom number formatting as #;#;"No";@

Regards,

 

[Yandeez]

That custom # format worked like a charm! Thanks for the help guys!