Vlookup on a blank key

G

gertiet

New Member
Joined
Oct 12, 2004
Messages
13
I am trying to set up an automatic vlookup, but some of the lookup values in my data table are blank - so I have set up a blank entry in my sorted lookup table as the first row, but the result is still coming back as N/A - how can I get a blank lookup value to return the corresponding value that I have set up in the table, so that everything continues to work (once the lookup values are fileld in)? Any assistance would be appreciated. Thanks.
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
Sort by date Sort by votes
Book7
ABCDEFG
1LookupTableLookupValueLOOKUPVLOOKUP
20   
32Q4QQ
45P9UU
57S
69U
7
Sheet1


Lookup table is sorted in ascending order w.r.t. the yellow area on column A.

Note the first row: a 0 and the formula ="".

F2:

=LOOKUP(E2,$A$2:$B$6)

G2:

=VLOOKUP(E2,$A$2:$B$6,2,1)
 
Upvote 0
thanks so much - the suggestion for the last suggestion - the 1st 2 didn't quite work, but a zero entry in my table is matching on the blanks. Thanks a lot.
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Solved
I need help trying to get a false return blank.
2
Replies
12
Views
380
Peter_SSs
Peter_SSs
T
  • Solved
VLOOKUP SUM with blank values
Replies
4
Views
277
AlanY
A
C
  • Solved
If VLOOKUP is @NA check Table 2
Replies
9
Views
513
Joe4
Joe4
N
  • Question
find data containing key words
2
Replies
11
Views
368
NdNoviceHlp
NdNoviceHlp
R
  • Question
VLOOKUP formula using the TEXT function as the "lookup value"
Replies
1
Views
815
awoohaw
awoohaw

Forum statistics

Threads
1,216,095
Messages
6,128,800
Members
449,468
Latest member
AGreen17

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top