VLookup Issue

[SPenney]

I'm running a standard vlookup that has the information to join. It
won't join, however, until I enter the cell that I'm using for the
Lookup_Value and exit. I can accomplish this quickly by hitting F2 and
enter, but my list is longer than I want to do this for. Does anyone
know why this is happening? Or how it fix it? I have tried changing
formats, which doesn't work.

thanks

SPenney

 

[RagDyer]

Check if your calculation is set to Auto.

<Tools> <Options> <Calculation> tab
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I'm running a standard vlookup that has the information to join. It
won't join, however, until I enter the cell that I'm using for the
Lookup_Value and exit. I can accomplish this quickly by hitting F2 and
enter, but my list is longer than I want to do this for. Does anyone
know why this is happening? Or how it fix it? I have tried changing
formats, which doesn't work.

thanks

SPenney

 

[Bob Umlas]

If I understand correctly, what you need to do is select all the VLOOKUP
formulas, then use Edit/Replace, and replace = with =, which has the effect
of re-entering every formula, what you are doing manually.
Bob Umlas
Excel MVP

 

[SPenney]

It wasn't turned on, but didn't solve the problem either.

SPenney

 

[SPenney]

I'm using F2 to enter the cell that the formula is referencing.
Replacing the = with = didn't work. Thanks for trying!

SPenney

 

[SPenney]

I found something that did work -- If I use find/replace for the cells
that I'm referencing, I can replace the character with itself and then
the formula will calculate properly. Definitely beats hitting F2 for a
few thousand lines.