I would like to sort data in column J to match the data in Column A. I have more items in the A column than J so in the event there is no match it simply skips that row until there is a match. At the end I would be able to compare the tier (column B) and value (column M) of a single item number.

G H 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 - A B 1004001 Tier A 1005004 Tier C 1005048 Tier C 1005059 Tier C 1005706 Tier A 1006506 Tier C 1006801 Tier A 1008501 Tier B 1009005 Tier A 1009038 Tier B 1009049 Tier B 1009107 Tier C 1009479 Tier D 1009480 Tier B 1009901 Tier C 1009923 Tier B 1009978 Tier 1010022 Tier C 1010081 Tier D C D Units GC Units CHM Units CHM Units CHM Units BIO Units CHM GC Units CHM Units CHM Units CHM Public He: CHM Units DSHM Units FI Public He: CHM Units EXC Units EXC Units DSHM Units DSHM Units DSHM E F Melting Point Ophthamology Ophthamology Ophthamology Performance Standards Renal Residual Solvents Ophthamology Hepatic Hepatic Hepatic Amino Acids Flavors & Fragrances Oncology Coatings Coatings Amino Acids DSHM Others Amino Acids . K . L 1005004 A1-C25-SO1-RM 1005048 A1-C29-SO3-LO 1005059 R4-D13-04-LM 1005706 A1-B02-501- 1006506 A1-B29-505- 1006801 A1-B05-SO3- 1008501 R1-D18-S06-LO 1009005 R1-D06-SO1-RO 1009479 A2-E02-SO2-LO 1009901 A1-B13-501- 1009923 A1-B15-S05- 1009978 A1-C29-SO2-RM 1010022 A1-C26-SO1-RO 1010081 A1-C31-SO2-LM 1010106 R1-D38-SO3-RO 1010208 R4-D34-SO1-LO 1011007 R1-D12-S06-LO 1011018 R1-D40-SO5-RO 1011029 R5-B22-SO3- . M I $3,697.02 $324.27 $415.80 $4,481.71 $43.80 $3,509.22 $160.00 $848.00 $0.00 $377.54 $766.21 $91.20 $243.04 $10.17 $67.86 $171.10 $5,132.81 $838.04 $718.17