Finding unique Value of corresponding duplicate value (Brain Teaser)

[cjain_560]

In one sheet I have data in one row (Style Number, Column A) which has many duplicates, but every corresponding value of that (each) duplicate value has a unique value (Item Code, Column B). In sheet 2, I have got just Style Number (Column A). How can I match the Column A in both the sheets (Sheet 1 and Sheet 2) and paste the corresponding unique value (Item Code) in Sheet 2 ? *Can't use V-Lookup since we are finding unique value from the duplicate itself*

Sheet 1 :

SS21 summary and master (1).xlsb
	A	B
1	Style Number	Item Code
2	KN012W	157847901
3	KN012W	157847902
4	KN012W	157847903
5	KN012W	157847904
6	KN012W	157847905
7	KN012W	157847906
8	QH039P	157060949
9	QH039P	157060950
10	QH039P	157060951
11	QH039P	157060952
12	QH039W	157060945
13	QH039W	157060946
14	QH039W	157060947
15	QH039W	157060948
16	QH040W	157060953
17	QH040W	157060954
18	QH040W	157060955
19	QH040W	157060956
20	QH040W	157060957
SS21 Master - Itemcode

Sheet 2 :

SS21 summary and master (1).xlsb
	A			D
1	Style			Item Code
2	BA0204A19
3	BA0249S20
4	BA0251S20
5	BA0289S21
6	BA0290S21
7	BA0291S21
8	BA0322S21
9	WP1174S21
10	WP1274S21
11	WP2174S21
12	WP1374S21
13	WP4374S21
14	WP2374S21
15	WP1474S21
16	WP5874S21
17	WP1674S21
18	WP6074S21
19	WP6174S21
20	WP1175S21
21	WP1275S21
22	WP2175S21
23	WP1375S21
24	WP4375S21
SS21 Summary File

Now, my data size is approximately around 9000 rows. Any help would be great. Thank you!

 

[Peter_SSs]

It is unclear to me what you want.
- Your sample data in each sheet seem to bear no resemblance to each other.
- If, say, QH039P was entered in the second sheet, what result do you want beside it given that there are 4 rows with that Style Number in the first sheet?