VLookup Question
 

Is there any way of getting around alphabetizing the first column in a
VLookup function?

What exactly do you mean?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jean" wrote in message
...
Is there any way of getting around alphabetizing the first column in a
VLookup function?

Set Range_Lookup to False. Then it will either find an exact match or
return "N/A".

Carlos

"Jean" wrote in message
...
Is there any way of getting around alphabetizing the first column in a
VLookup function?

No need to sort ascending the first column of your lookup
table if you specify "exact match" in your VLOOKUP
formula. Use "0" or FALSE in the fourth argument:

=VLOOKUP(---,---,---,0)

HTH
Jason
Atlanta, GA

-----Original Message-----
Is there any way of getting around alphabetizing the
first column in a
VLookup function?
.