Hello All,

Problem with a VLOOKUP. EX: When "Elmer Fudd" is chosen from the drop down
in a spreadsheet, EF should auto appear in the appropriate colmun. But "AP"
for APPLE PIE shows up. All others work.
Formula is =IF(C2=0," ",(VLOOKUP(C2,$AM$1:$AN$11,2)))
COLUMN AM COLUMN AN
ROW1 APPLE PIE AP
2 GREEN BEANS GB
3 RED APPLES RB
4 ORANGE CARROTS OC
5 LIMA BEANS LB
6 SNOW WHITE SW
7 BUGS BUNNY BB
8 ELMER FUDD EF

Thank you everyone!
COLUMN AM HOLDS THE NAME AND COLUMN AN HOLDS THE INITIALS