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 |
#2
|
|||
|
|||
if it is vlookup have you tried using the last argument in vlookup formula
as <false klm96 wrote in message ... 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 |
#3
|
|||
|
|||
Use VLOOKUP()
The last argument should be FALSE to indicate that you want an exact match. Use an IF statement for your desired error message. Mangesh "klm96" wrote in message ... 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 |
Reply |
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 |