Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
index,match - how to avoid same lookup when duplicates present | Excel Worksheet Functions | |||
if/lookup/index/match? | Excel Worksheet Functions | |||
Lookup or Index/Match | Excel Discussion (Misc queries) | |||
lookup/index/match - help! | Excel Discussion (Misc queries) | |||
Lookup/Index/Match HELP! | Excel Discussion (Misc queries) |