After making sure that both columns were General, instead of one being Text
and one being General, my issue turned out to be that I was not using
absolute reference in the vlookup formula. Once I put the $ in, e.g
$a$1:$b$234, I saw data results instead of the formula. Thanks for pointing
me in the right direction.
--
Marilyn Collins


"Kassie" wrote:

Could be that the cells containing the formulae are formatted as text?
Make sure the cells are formatted as general
Press <F2
Delete the "=" sign
Insert a new "=" sign
Press <Enter
See if it works

--
Hth

Kassie Kasselman
Change xxx to hotmail


"Marilyn Collins" wrote:

I can see the result in the VLOOKUP Wizard box, but when I click OK I get the
formula in the cell, not the result. Can anyone help/ Thanks.
--
Marilyn Collins