Return Blank Cell for VLookup if #N/A

[tl1735]

Good Day Everyone,
I am sure it likely has been discussed before, but I have searched for it but was unable to find a clear answer...

I'm running a VLookup and I want it to return a 0 or blank of the VLookup normally returns an #N/A result.

Can someone please help me out?

Thanks very much for all your help.

[Palmetto]

You would have to nest the VLOOKUP in an IF function, which forces Excel to do the look up twice (inefficient).

However:

=IF(ISNA(VLOOKUP(A1,D1:E20,2,0)),"",VLOOKUP(A1,D1:E20,2,0))

It is more efficient to allow VLOOKUP to return the #N/A and use a helper cell to return a valid result.

Helper cell, say C1: =IF(ISNA(B1),"",B1)

Set the results cell to look at the helper cell: =C1

[tl1735]

Tremendous!

Thanks!!