Report

Duplicate values in multiple columns [Solved]

Ask a question M3TM3T 2Posts Saturday November 5, 2016Registration date November 5, 2016 Last seen - Last answered on Nov 5, 2016 01:25PM
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 
Helpful
+2
moins plus
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
M3TM3T 2Posts Saturday November 5, 2016Registration date November 5, 2016 Last seen - Nov 5, 2016 01:25PM
Hurrah
You are my hero. thanks a lot.
It works like a charm.
Reply
Add comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!