The cell currently being evaluated contains a constant
 

I have a Workbook containing 3 worksheets and am running 2 "VLOOKUP" columns
from 1 worksheet referencing the other 2.
My formulas are '=VLOOKUP(A155,Sheet3!$A$1:$G$440,4,FALSE)' this gives me
the correct answer, and
'=VLOOKUP(A155,Sheet2!$A$2:$F$402,4,FALSE)' this gives me an incorrect
answer. I have verified the data is in the relevant worksheet, however i get
the result of #N/A for the second formula.
I have copied and pasted all data, as values only, into a new spreadsheet
and still get the same result.
I am starting to go crazy working this out. Can anybody help me please?

The cell currently being evaluated contains a constant
 

It means that whatever's in A155 is not in your Sheet2 table. It could be
extraneous blanks, unprintable characters, extra decimal places, etc.

If you still can't find the error, post your spreadsheet to a public
website, and someone will find it for you.

Regards,
Fred

"Frustrated" wrote in message
...
I have a Workbook containing 3 worksheets and am running 2 "VLOOKUP"
columns
from 1 worksheet referencing the other 2.
My formulas are '=VLOOKUP(A155,Sheet3!$A$1:$G$440,4,FALSE)' this gives me
the correct answer, and
'=VLOOKUP(A155,Sheet2!$A$2:$F$402,4,FALSE)' this gives me an incorrect
answer. I have verified the data is in the relevant worksheet, however i
get
the result of #N/A for the second formula.
I have copied and pasted all data, as values only, into a new spreadsheet
and still get the same result.
I am starting to go crazy working this out. Can anybody help me please?