Get VLOOKUP to return text on N/A and 0 results

[cicjospencer]

I have a VLOOKUP formula where if the result is "#N/A" or "0" I want the cell to return the text "not provided".

I'm sure a nested formula would work, but I can't figure it out. Here's my formula at present:

=IF(ISNA(VLOOKUP([Tracker Site ID],Table17,5,0)),"not provided",VLOOKUP([Tracker Site ID],Table17,5,0))

Any help is greatly appreciated.

 

[Joe4]

Welcome to the Board!

One way:

[COLOR=#333333]=IF(ISNA(VLOOKUP([Tracker Site ID],Table17,5,0)),"not provided",IF(VLOOKUP([Tracker Site ID],Table17,5,0)=0,"not provided",[/COLOR][COLOR=#333333]VLOOKUP([Tracker Site ID],Table17,5,0)[/COLOR][COLOR=#333333]))[/COLOR]

 

[Special-K99]

Try

=IF(OR(ISNA(VLOOKUP([Tracker Site ID],Table17,5,0)),VLOOKUP([Tracker Site ID],Table17,5,0)=0),"not provided",VLOOKUP([Tracker Site ID],Table17,5,0))