VLOOKUP functionality

  • Thread starter Thread starter Crimson King
  • Start date Start date
C

Crimson King

How can I get results from an unsorted database in Excel similar to the way
VLOOKUP works in a sorted database
 
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?
 
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


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?
Click to expand...
 
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


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.
Click to expand...
 

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

Similar Threads

VLOOKUP 2
Auto sort help. 2
vlookup challenge with hyphen data placement 2
vlookup to txt file or database 5
EXCEL - IF(IFERROR(VLOOKUP question 0
use VLookup to copy more than 1 cell 3
Worksheet Code 4
Vlookup using multiple worksheets 2

Back
Top