C
Crimson King
How can I get results from an unsorted database in Excel similar to the way
VLOOKUP works in a sorted database
VLOOKUP works in a sorted database
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
T. Valko
So, does that mean if an exact match isn't found you want the closest match
that is less than the lookup value? Are you looking up numbers?
that is less than the lookup value? Are you looking up numbers?
C
Crimson King
Biff, Thanks for the reply...No not looking up numbers - looking up
alphanumericals to return aplhanumericals from a different column. The Look
Up criteria should be an exact match.
--
Many Thanks,
CK
alphanumericals to return aplhanumericals from a different column. The Look
Up criteria should be an exact match.
--
Many Thanks,
CK
T. Valko said:So, does that mean if an exact match isn't found you want the closest match
that is less than the lookup value? Are you looking up numbers?
T
T. Valko
Ok, you can use VLOOKUP for that. Just set the 4th argument to either 0 or
FALSE. That means you want an exact match and the data does not need to be
sorted.
=VLOOKUP(A1,D:E,2,0)
=VLOOKUP(A1,D:E,2,FALSE)
--
Biff
Microsoft Excel MVP
FALSE. That means you want an exact match and the data does not need to be
sorted.
=VLOOKUP(A1,D:E,2,0)
=VLOOKUP(A1,D:E,2,FALSE)
--
Biff
Microsoft Excel MVP
Crimson King said:Biff, Thanks for the reply...No not looking up numbers - looking up
alphanumericals to return aplhanumericals from a different column. The
Look
Up criteria should be an exact match.
C
Crimson King
Biff,
Many thanks for your quick and perfect solution.
Many thanks for your quick and perfect solution.
T
T. Valko
You're welcome. Thanks for the feedback!