vlookup not yeilding result (just the formula itself)

B

BL

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?
 
R

Rob Bovey

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
 
B

Bill Manville

Try Tools / Options / View / uncheck Formulas

Bill Manville
MVP - Microsoft Excel, Oxford, England
 
B

BL

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.
 
B

BL

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.
 
R

Rob Bovey

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
 
B

Bill Manville

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
 
Top