VLOOKUP not calculating - workbook protection issue?

[DuncanR]

I am trying to use the VLOOKUP function below, but when I type the formula in, which seems to be correct, no result occurs (not even the normal "N/A) and the cell just lists the formula as I type it. Is there some protection setting that prevents VLOOKUP results that I am missing?

In Sheet1 Col2, I am trying to confirm that the invoice# in Col1 exists in Sheet2 Col6 which has 258 rows of data with 6 columns of data:

Sheet1 Col2:
=VLOOKUP(A1,'Sheet2'!$A$1:$F$258,6,FALSE)

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com

 

[Mike]

2 things to try.

Firstly are you typing into a cell formatted as text? if so cut the formula
out, change the format to general and paste the formula back.

Second. Press ctrl ` (The ` is below the esc key). This toggles between view
formula and view values.

Mike

 

[Joel]

Evrything look good
I assume A1 is on sheet 1. That you are looking a column F on sheet 2. the
only thing that can be wrong is that the data on one sheet is text and the
other sheet is a number. check to see if a ' is in front of the data.

You can also double check the lookup by using the Edit Menu Find and
pastting what is in A1 into the find. Us the Option in find Within Workbook.
then find all. See if Find actually locates the data on sheet 2.

 

[Gord Dibben]

Mike

No need to cut and paste after re-formatting.

Just F2 and ENTER will do same thing.


Gord Dibben MS Excel MVP