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
|