Problem getting vlookup to work

fatnhappy

Board Regular
Joined
Nov 8, 2003
Messages
132
Hi everyone!

Here is my formula:

=VLOOKUP(F12,'Offices and Zips'!$E$2:$F$80,2,0)

F12 is a formula that returns a value into this cell. The vlookup doesn't work if I have the formula in there, but if I take out the formula and insert the result of the formula, then the vlookup works great. I checked to ensure all the cells are formatted the same, and they are, so now I am stuck....Any ideas?
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
For the last entry in the formula, instead of 0, try FALSE. That's what I use.

How does that work?
 
Upvote 0
Does this work?

=VLOOKUP(VALUE(F12),'Offices and Zips'!$E$2:$F$80,2,0)
 
Upvote 0
Can you post the formula in F12, and maybe a shot of the data?
For the last entry in the formula, instead of 0, try FALSE.
Just an FYI, 0 & FALSE are interchangeable in a VLOOKUP, as are 1 & TRUE. It's just a matter of preference.

Smitty
 
Upvote 0
NBVC -

Your are definitely the Man!! (or woman) That worked awesome. I knew there was a way to lookup the value of the cell, but I didn't know it was as easy as valud(f12)
 
Upvote 0
fatnhappy said:
NBVC -

Your are definitely the Man!! (or woman) That worked awesome. I knew there was a way to lookup the value of the cell, but I didn't know it was as easy as valud(f12)

What's the formula in F12?
 
Upvote 0

Forum statistics

Threads
1,211,848
Messages
6,104,354
Members
447,902
Latest member
chriswebs23

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