| 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? |
| 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 | |||
Threaded Mode
