Vlookup

M

Mickey

I receive in the cell the command "=VLOOKUP(A10,'hours'!A2:O151,9,false)"
instead of getting the result itself. any Idea why?
 
B

Bob Umlas, Excel MVP

The cell is formatted as Text. Use Format/Cells, change to General (or
whatever you want), then re-enter the formula (F2/Enter)
 
D

DaveT

Is the cell you have place the formula in formatted as a text cell?
If so you will have to delete the formula reformat as general (or other)
replace formula

Regards
Dave
 
G

Gord Dibben

Mickey

Perhaps the cell was pre-formatted as Text.

Re-format to General and F2 and ENTER.


Gord Dibben MS Excel MVP
 
Top