I want "" as the result when VLOOKUP can't find an exact match.

[Dave H.]

In using VLOOKUP, I have an application where I'd like to have the result ""
(instead of '#N/A' where the source list does not contain the requested
record. How do I do that? with an 'if' statement of some kind? ...?

 

[Kassie]

Hi Dave

Here is an example from one of my sheets, which shows how to do it

=IF(ISNA(K5),VLOOKUP(B4,Customers,2,FALSE)&VLOOKUP(B4,Customers,3,FALSE),"")

 

[Kassie]

Sorry, posted the wrong one. Try this, and obviously do the lookup after the
""

=IF(ERROR.TYPE(VLOOKUP($B$4,Customers,2,FALSE))=7,"")

 

[Ken Wright]

=IF(ISNA(Your_Formula),"",Your_Formula)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission
------------------------------­------------------------------­----------------