VLOOKUP functionality

C

Crimson King

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


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...
 
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


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

Auto sort help. 2
Excel 2002: Any formulas to look up unsorted column ? 1
vlookup to txt file or database 5
use VLookup to copy more than 1 cell 3
Sum Vlookup where there are blanks 1
EXCEL - IF(IFERROR(VLOOKUP question 0
How to print selected columns that are not adjacent in Excel 2
VLOOKUP 2

Top