VLOOKUP displaying "NO ANSWER" instead of "0"

[ksean]

When using this formula everything works great as long as an answer can be
found but when an answer can't be found the answer displays as a "0". What do
I have to add to the formula to get it to display a "No Answer" when the
answer can't be found?

=IF(ISERROR(VLOOKUP(B3,Master!$A$3:$O$4180,2,FALSE)),IF(ISERROR(VLOOKUP(B3,Master!$E$3:$O$4180,2,FALSE)),IF(ISERROR(VLOOKUP(B3,Master!$I$3:$O$4180,2,FALSE)),VLOOKUP(B3,Master!$I$3:$O$4180,2,FALSE)),VLOOKUP(B3,Master!$E$3:$O$4180,2,FALSE)),VLOOKUP(B3,Master!$A$3:$O$4180,2,FALSE))


Thanks
Ksean

 

[ksean]

The source cell was totall empty, once something was put in it the formula
returned the "NO ANSWER" just as I wanted it to.

 

[Fred Smith]

To display "No answer" when the lookup value is not found, do it this way:
=if(isna(vlookup(...)),"No answer",vlookup(...))

Regards,
Fred.