Problem getting vlookup to work

[fatnhappy]

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?

 

[Kati37]

For the last entry in the formula, instead of 0, try FALSE. That's what I use.

How does that work?

 

[fatnhappy]

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

 

[fatnhappy]

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

 

[NBVC]

Does this work?

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

 

[Smitty]

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

 

[fatnhappy]

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)

 

[Brian from Maui]

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?