Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Alternate to Lookup?
I need to look up a value in Column A, and report the corresponding value
from corresponding column C. If the value is not found in A, I want some sort of error message or text to indicate this result. "If LOOKUP can't find the lookup_value, it matches the largest value in lookup_vector that is less than or equal to lookup_value", this would be misleading. I should mention that I am looking between two worksheets with this one. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lookup more than one cell | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Lookup Function Problem | Excel Discussion (Misc queries) | |||
Lookup function w/Text and Year | Excel Worksheet Functions | |||
double lookup, nest, or macro? | Excel Worksheet Functions |