Solved: How do I get Vlookup to work????????

[sandy.robb]

Sheet 1 (A2:F17990)
A B C D
AUApplicationNo Applicant IPCM
#N/A AU20032000 Automative F01B


Sheet 2 (A2:AS9) - Sample below
A B C D E F …………….
ME21 Mechanical tools B21B B21C B21D B21F
ME22 Engines F01B F01C F01D F01K
ME23 Mech elem'ts F15B F15C F15D F16B


Formula in Sheet1!A2 is =VLOOKUP(D2,Sheet2!A2:AS9,1,FALSE)
but returns #N/A when ME22 is expected. What is wrong?

[venkat1926]

in vlookup the lookup value must be in the first column but D2 is in 4th column

try this formula


=INDEX(A1:A9,MATCH(D2,D1:D9,0),1)

[sandy.robb]

Solved

[mdmackillop]

Hi Sandy,
Welcome to VBAX, and an immediate result as well!
FYI, you can attach a workbook using Manage Attachments in the Go Advanced section.
Regards
MD