index,match - how to avoid same lookup when duplicates present

[klk1976]

Help. Index, Match is always pulling the first vendor identified.
Please see below. I am trying to match Rate1 & Rate 2 to Vendors A,B,
and then pull down the name for each vendor in the Ven1 and Ven
columns. As you can see Ven2 is pulling down the letter "A" when
would like it to pull down "C".

Ven1 =INDEX($E$2:$G$2,MATCH(A3,$E3:$G3,0))
Ven2 =INDEX($E$2:$G$2,MATCH(B3,$E3:$G3,0))


Rate1 Rate2 Ven1 Ven2 A B C
66 66 A A 66 55 6

 

[Mazzaropi]

Help. Index, Match is always pulling the first vendor identified.
Please see below. I am trying to match Rate1 & Rate 2 to Vendors A,B,
and then pull down the name for each vendor in the Ven1 and Ven
columns. As you can see Ven2 is pulling down the letter "A" when
would like it to pull down "C".
Ven1 =INDEX($E$2:$G$2,MATCH(A3,$E3:$G3,0))
Ven2 =INDEX($E$2:$G$2,MATCH(B3,$E3:$G3,0))

Rate1___ Rate2___ Ven1____Ven2____A_______B_______C
_66______66______A________A_____66______55______66

Dear klk1976[/b[, Good Afternoon.

In this case the MATCH function get always the first argument that i
found.
And it´s correct.

AS you have duplicated values then it's necessary to create a criteri
to solve the draw situation.

Imagine when all the three will have the same value.
That´s my opinion.

--Some minute
later------------------------------------------------------

After my answer, I found a topic that can solve your problem.
Take a look at: http://www.excelbanter.com/showthread.php?t=115054

Good Luc