Is there any way of getting around alphabetizing the first column in a VLookup function?
J Jean Dec 28, 2004 #1 Is there any way of getting around alphabetizing the first column in a VLookup function?
B Bob Phillips Dec 28, 2004 #2 What exactly do you mean? -- HTH RP (remove nothere from the email address if mailing direct)
C CarlosAntenna Dec 28, 2004 #3 Set Range_Lookup to False. Then it will either find an exact match or return "N/A". Carlos
J Jason Morin Dec 28, 2004 #4 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
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
