If a VLookUp returns a #N/A

[piggylumps]

Morning everyone, can anyone help with this little problem.

If a vlookup formula returns a #N/A value, can that #N/A be turned into text usuing an IF statement?

eg:

=IF(E7="#N/A","Loaded Awaiting Response",E7)

E7 is the result of the original vlookup formula.

 

[VoG]

Try like this

=IF(ISNA(your formula),"Loaded Awaiting Response",your formula)

 

[Andrew Poulsom]

Try:

=IF(ISNA(E7),"Loaded Awaiting Response",E7)

 

[piggylumps]

Excellent, thank you Andrew. And Kudo's on the speedy reply

 

[cstimart]

you'll want to use "ISERROR".

=IF(ISERROR(VLOOKUP(D1,A:C,1,FALSE)),"Message",VLOOKUP(D1,A:C,1,FALSE))