Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cell currently being evaluated contains a constant | Excel Discussion (Misc queries) | |||
CONCATENATE text to create a formula to be evaluated | Excel Worksheet Functions | |||
"the cell currently being evaluated contains a constant" | Excel Discussion (Misc queries) | |||
Formula not evaluated automaticly in Office 2003 | Excel Worksheet Functions | |||
the cell currently being evaluated contains a constant | Excel Worksheet Functions |