Duplicate values in multiple columns [Solved/Closed]

M3TM3T 2 Posts Saturday November 5, 2016Registration date November 5, 2016 Last seen - Nov 5, 2016 at 12:23 PM - Latest reply: M3TM3T 2 Posts Saturday November 5, 2016Registration date November 5, 2016 Last seen
- Nov 5, 2016 at 01:25 PM
Hello,
I'm looking for a formula for a case mentioned below:
Consider we have values in three columns



I need to find a formula which compare columns B and C, wherever values of B are repeated in C, return customer's number in D. for example. in first row, the main value is 0.5 which goes to costumer NO 1. the value of 0.5 is repeated for costumer 3 so I need formula print the value 3 (costumer NO) in column D
RED values are my desired answers
I am grateful for any help.

See more 

2 replies

Mazzaropi 1826 Posts Monday August 16, 2010Registration dateContributorStatus April 15, 2018 Last seen - Nov 5, 2016 at 12:34 PM
+2
Helpful
1
M3TM3T, Good afternoon.

Try to use:

D2 --> =INDEX($A$2:$A$7, MATCH(C2, $B$2:$B$7, 0))

Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Was this answer helpful?  
M3TM3T 2 Posts Saturday November 5, 2016Registration date November 5, 2016 Last seen - Nov 5, 2016 at 01:25 PM
Hurrah
You are my hero. thanks a lot.
It works like a charm.