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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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? ...?
 
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),"")
 
Sorry, posted the wrong one. Try this, and obviously do the lookup after the
""

=IF(ERROR.TYPE(VLOOKUP($B$4,Customers,2,FALSE))=7,"")
 
=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 :-)
------------------------------­------------------------------­----------------
 
Back
Top