Mike

No need to cut and paste after re-formatting.

Just F2 and ENTER will do same thing.


Gord Dibben MS Excel MVP

On Wed, 21 Feb 2007 09:43:05 -0800, Mike wrote:

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

"DuncanR" wrote:

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