VLookup Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
Set Range_Lookup to False. Then it will either find an exact match or
return "N/A".

Carlos
 
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
 
You must log in or register to reply here.

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

Dynamic col_index_num in VLOOKUP? 5
Need VLOOKUP to Work Two Ways 0
Vlookups not working 2
vlookup formatting problem 1
Help With VLOOKUP 2
Vlookyp fails due to space at the end 2
Vlookup & "space" vlookup 2
Excel IF statement with vlookup 2

Back
Top