Finding unique Value of corresponding duplicate value (Brain Teaser)

cjain_560

New Member
Joined
Mar 10, 2021
Messages
10
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
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
AB
1Style NumberItem Code
2KN012W157847901
3KN012W157847902
4KN012W157847903
5KN012W157847904
6KN012W157847905
7KN012W157847906
8QH039P157060949
9QH039P157060950
10QH039P157060951
11QH039P157060952
12QH039W157060945
13QH039W157060946
14QH039W157060947
15QH039W157060948
16QH040W157060953
17QH040W157060954
18QH040W157060955
19QH040W157060956
20QH040W157060957
SS21 Master - Itemcode


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


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

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off
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?
 
Upvote 0

Forum statistics

Threads
1,213,531
Messages
6,114,167
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top