Index match

[aarti_rto]

Hello,
i have duplicate values i.e part no in one column & i need to extract the stock qty of the part in next column but in only one cell with respective supplier as shown below.
kindly help.

Required -

Supplier	Part No	Stock As on Date
AAA	ABC	100
BBB	CBD	200
CCC	XYZ	100
DDD	XYZ	700
EEE	CBD	400
CCC	XYZ	0
BBB	CBD	0

Data Source -

Supplier	Part Source	Stock
AAA	ABC	100
BBB	CBD	200
CCC	XYZ	100
DDD	ABC	300
EEE	CBD	400​
CCC	ABC	600
DDD	XYZ	700

 

[alansidman]

{=INDEX($H$2:$H$8,MATCH(A2,$F$2:$F$8,0),MATCH(B2,$G$2:$G$8,0))} Make sure that you don't just click on the enter key, you need to click on CTL +Shift+ Enter to get the curly brackets.

 

[aarti_rto]

hi,
Thanks for the help , but when i apply this formula it applies to all fields , i mean in case of duplicate data in a column of supplier i need only first cell to add qty and second or all other duplicates should Zero OR Blank

pl help

 

[Fluff]

Duplicate to: If ,index , match

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.