Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using a cell with a formula in it for lookup value
I have been unable to find out if this is a limitation in Excel or a
mistake on my end. I have a vlookup function, everything is same format, trimmed, etc.... The lookup value contains a formula referring to another sheet and this is the only thing I can think of that's generating the dreaded "N/A" error. Also, the index column in the lookup array is composed of a formula pointing to yet another sheet. I hope my question makes sense! Looking forward to some help-- thanks all! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Get Cell Address From Lookup (Alternative to Lookup) | Excel Worksheet Functions | |||
Incrementing cell reference in Lookup formula | Excel Worksheet Functions | |||
Use Cell Address Lookup in formula | Excel Worksheet Functions | |||
formula to lookup value and return value from cell at left of target | Excel Worksheet Functions | |||
Formula to lookup cell value | Excel Discussion (Misc queries) |