vlookup not yeilding result (just the formula itself)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I create a worksheet from a citrix server then add a column to due a VLOOKUP.
In the cell of my formula only the formula itself shows and not the result
of the formula. The field is formatted as general (not text). Can anyone
help me?
 
BL said:
I create a worksheet from a citrix server then add a column to due a
VLOOKUP.
In the cell of my formula only the formula itself shows and not the result
of the formula. The field is formatted as general (not text). Can anyone
help me?
Click to expand...

The most common reason for this happening is that formula view is turned
on. Choose Tools/Options from the menu and on the View tab make sure the
Formulas checkbox is not checked under the Window Options section at the
bottom of the tab.

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm
 
Try Tools / Options / View / uncheck Formulas

Bill Manville
MVP - Microsoft Excel, Oxford, England
 
Thanks for taking the time to respond. However, I tried your suggestion and
it did not work. A co-worker helped me resolve the problem. She said to
choose DATA>TEXT TO COLUMNS>NEXT>NEXT>FINISH. Worked like a charm. Why? I
have no idea. Hope this helps.
 
Thanks for taking the time to respond. However, I tried your suggestion and
it did not work. A co-worker helped me resolve the problem. She said to
choose DATA>TEXT TO COLUMNS>NEXT>NEXT>FINISH. Worked like a charm. Why? I
have no idea. Hope this helps.
 
BL said:
Thanks for taking the time to respond. However, I tried your suggestion
and
it did not work. A co-worker helped me resolve the problem. She said to
choose DATA>TEXT TO COLUMNS>NEXT>NEXT>FINISH. Worked like a charm. Why?
I
have no idea. Hope this helps.
Click to expand...

It sounds like your lookup table was not a true table (i.e. one value
per cell for multiple columns) but a series of values all entered into the
same cell.

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm
 
OK, so the cell WAS formatted as text and you changed it to general,
but you also have to re-enter the formula to get it to stop being
treated as text. That's what the Text to columns trick does.

Bill Manville
MVP - Microsoft Excel, Oxford, England
 
Back
Top