sandy.robb
08-31-2006, 12:02 AM
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?
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?