If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|