Hi,
I have a workbook with 2 sheets
sheet1: part numbers are listed in column D for 1200 rows
A B C D E F G H.....
1Y54
HH34
1234
2156
JEE7
21GTR
column E should ideally give the result of a formula that finds the customer name from a matrix in sheet2
Sheet2:
A B C D E F G H .......
ROW1 SEER TOTO GEER INSA KILE
ROW2 024 2156 999 12548 G125
ROW3 LFG222 HN54 1234 229G1 21GTR
ROW4 YT221 U33 UB40 JEE7 555A
RESULT:
A B C D E F G H.....
1Y54 N/A
HH34 N/A
1234 GEER
2156 TOTO
JEE7 INSA
21GTR KILE
Thank you in advance for any help
Bookmarks