The cell currently being evaluated contains a constant

F

Frustrated

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?
 
F

Fred Smith

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
 

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

"the cell currently being evaluated contains a constant" 1
Data Validation "The Source Currently Contains an Error" 0
IF statement with multiple VLOOKUPs 0
cell currently being evaluated contains a constant 2
Cell values not being properly evaluated by VLOOKUP() orSUMPRODUCT()... why? 1
Macro 3
Array Constant 3
Embed the same Excel multiple times 0

Top