Alternate to Lookup?

K

klm96

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
 
M

Mangesh Yadav

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top