Vlookup

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

Guest

I receive in the cell the command "=VLOOKUP(A10,'hours'!A2:O151,9,false)"
instead of getting the result itself. any Idea why?
 
The cell is formatted as Text. Use Format/Cells, change to General (or
whatever you want), then re-enter the formula (F2/Enter)
 
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
 
Mickey

Perhaps the cell was pre-formatted as Text.

Re-format to General and F2 and ENTER.


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamic col_index_num in VLOOKUP? 5
vlookup formatting problem 1
VLOOKUP IS ERROR 3
Vlookups not working 2
How do I insert a dynamic reference of a range inside VLOOKUP? 4
Avoiding redundant calculations 7
Using VLOOKUP results in a DSUM criteria range 2
Vlookup in multiple columns 2

Back
Top