VLookup Question

J

Jean

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

Bob Phillips

What exactly do you mean?

--

HTH

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

CarlosAntenna

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

Carlos
 
J

Jason Morin

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
 

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

Help With VLOOKUP 2
Mail Merge Directory Conditional Page Break 0
vlookup formatting problem 1
Can I add a formula or function to Vlookup? 1
VLOOKUP & Data Validation 0
Vlookup 1
VLOOKUP Not working 3
renaming tabs to fit formulas 0

Top