VLookup - result (cell) shows formula, not lookup data

[Marilyn Collins]

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.

 

[Sheeloo]

Try changing the cell format (for the cell having the formula) to GENERAL...
Most likely it is set to TEXT

If you see formulas in ALL cells then press CTRL-` once.

 

[Kassie]

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

 

[Marilyn Collins]

Cell format was Text and I changed it to General. I still got the formula.
I will populate all the cells (with the formula); can you tell me again what
I do after I press the control key: press CTRL-` (I don't understand that
last part). Thanks so much.

 

[Francis]

delete the current formula or content in the cell
format the cell as General
re-enter the formula again or

Press Ctrl and ` which is locate above the Tab key


--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another

 

[Marilyn Collins]

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.