View Single Post
  #1   Report Post  
GijsKijlstra GijsKijlstra is offline
Junior Member
 
Location: Singapore
Posts: 20
Send a message via Skype™ to GijsKijlstra
Default Index match formula with multiple conditions

I want the cell value from column F, matching Name (column A) and Driver (column C).

I’m trying to use Index match formula with multiple conditions: F103 cell {=INDEX(F$2:F$98,MATCH(1,($A$2:$A$98=$A103)*($C$2: $C$98=$C103),0))}

When there are multiple entries in column F for one name (from column A), only present one value for that name in F100-F112.
(E.g. F2, F3, F4, F6, F9, F10, F11 match the same name in a2, a3, a4, a6, a9, a10, a11, but should only and is correctly presented with one value in F100, 38%)

Inspecting, I’m getting the right value in e.g. F100 but a wrong value in F103).

Can someone help me, please. Thanks in advance,
Gijs
Attached Images