# Problem getting vlookup to work

#### fatnhappy

##### Board Regular
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?

0 and "False" are interchangeable, but I tried it for giggles, and it didn't work.....

0 and "False" are interchangeable, but I tried it for giggles, and it didn't work.....

Does this work?

=VLOOKUP(VALUE(F12),'Offices and Zips'!\$E\$2:\$F\$80,2,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

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)

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?

Replies
9
Views
369
Replies
4
Views
199
Replies
7
Views
183
Replies
10
Views
439
Replies
14
Views
457

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.

### Which adblocker are you using?

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

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