ExcelBanter - Vlookup

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Vlookup (https://www.excelbanter.com/excel-worksheet-functions/117058-vlookup.html)

mickey

Vlookup

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

Bob Umlas, Excel MVP

Vlookup

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

"Mickey" wrote:

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

DaveT

Vlookup

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" wrote:

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

Gord Dibben

Vlookup

Mickey

Perhaps the cell was pre-formatted as Text.

Re-format to General and F2 and ENTER.

Gord Dibben MS Excel MVP

On Wed, 1 Nov 2006 08:19:02 -0800, Mickey
wrote:

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

All times are GMT +1. The time now is 11:47 PM.