ExcelBanter - VLOOKUP FORMULA IS DISPLAYED AS THE RESULT

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - VLOOKUP FORMULA IS DISPLAYED AS THE RESULT (https://www.excelbanter.com/excel-discussion-misc-queries/102382-vlookup-formula-displayed-result.html)

tony

VLOOKUP FORMULA IS DISPLAYED AS THE RESULT

I am using a VLOOKUP, but Excel displays the actual formula in the cell, not
the retun value. The return value in the formula box is correct, however.

Mike_D

VLOOKUP FORMULA IS DISPLAYED AS THE RESULT

Your CELLS are still in the text format.
Highlight the cell and go to the menu DataText to columnsFinish

--
Mike_D
------------------------------------------------------------------------
Mike_D's Profile: http://www.excelforum.com/member.php...o&userid=36969
View this thread: http://www.excelforum.com/showthread...hreadid=566900

All times are GMT +1. The time now is 08:45 AM.