ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Using VLLOKUP (https://www.excelbanter.com/excel-worksheet-functions/9701-using-vllokup.html)

Cessna12

Using VLLOKUP
 
When I enter the function in a cell, the result is correct in the set up.
When I hit enter, the only thing taht is up into the cell is the VLOOKUP
formula and not the result of the formula.

Jason Morin

The cell may have been formatted as text, and thus Excel
doesn't recognize your formula as a true formula, only as
a text string. To fix it:

1. Select the cell.
2. Press <Ctrl<Shift<~.
3. Press F2.
4. Press <Enter.


HTH
Jason
Atlanta, GA

-----Original Message-----
When I enter the function in a cell, the result is

correct in the set up.
When I hit enter, the only thing taht is up into the

cell is the VLOOKUP
formula and not the result of the formula.
.



All times are GMT +1. The time now is 03:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com