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,C and then pull down the name for each vendor in the Ven1 and Ven2 columns. As you can see Ven2 is pulling down the letter "A" when I 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