I need the ability to take a part number from column C and find it in
column A and when it finds a match, copy the contents from the
corresponding cell in column B and paste it in the cell in column D
next to the corresponding part number in column C. An example would
be finding part number 00323 in cell C6 and matching it to the part
number in cell A7 and copying PTS from cell B7 to cell D6 or finding
part number 00350 in cells C8, C9, and C10 and matching with the same
part number in cell A9 and copying ACC from cell B9 to cells D8, D9
and D10.

Thanks for any and all help.

Tom




A B C D E
PART_NBR2 SPC Part Number. WC

1 00063 LSI 00069 126
2 00144 BKS 00069 127
3 00207 PAR 00159 126
4 00227 LSI 00159 127
5 00293 LSI 00276 109
6 00307 LSI 00323 700
7 00323 PTS 00349 126
8 00349 ACC 00350 113
9 00350 ACC 00350 113
10 00358 LSI 00350 121
11 00359 LSI 00372 126
12 00361 LSI 00372 127
13 00399 BKS 00378 126

Enter in D6 =VLOOKUP(C6,A1:B13,2,FALSE)

Array enter in D8:D10 =VLOOKUP(C8:C10,A1:B13,2,FALSE)

Alan Beban

Tom wrote:
I need the ability to take a part number from column C and find it in
column A and when it finds a match, copy the contents from the
corresponding cell in column B and paste it in the cell in column D
next to the corresponding part number in column C. An example would
be finding part number 00323 in cell C6 and matching it to the part
number in cell A7 and copying PTS from cell B7 to cell D6 or finding
part number 00350 in cells C8, C9, and C10 and matching with the same
part number in cell A9 and copying ACC from cell B9 to cells D8, D9
and D10.

Thanks for any and all help.

Tom




A B C D E
PART_NBR2 SPC Part Number. WC

1 00063 LSI 00069 126
2 00144 BKS 00069 127
3 00207 PAR 00159 126
4 00227 LSI 00159 127
5 00293 LSI 00276 109
6 00307 LSI 00323 700
7 00323 PTS 00349 126
8 00349 ACC 00350 113
9 00350 ACC 00350 113
10 00358 LSI 00350 121
11 00359 LSI 00372 126
12 00361 LSI 00372 127
13 00399 BKS 00378 126

Thanks, that worked great.

I inserted a column in front of Column A and now i need to take the
list, that is now in Column B and look for a match in the list that is
now in Column D and if it doesn't find a match, then paste the words,
NO MATCH, in Column A next to the corresponding part number in column
B.