Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I want the cell value from column F, matching Name (column A) and Driver (column C).
I知 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知 getting the right value in e.g. F100 but a wrong value in F103). Can someone help me, please. Thanks in advance, Gijs |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Return value with 2 conditions (using Lookup/Match/Index) | Excel Discussion (Misc queries) | |||
VLOOKUP MATCH INDEX two conditions / criterias text and date | Excel Worksheet Functions | |||
index(match) Wind Uplift Calculations (match four conditions) | Excel Worksheet Functions | |||
lookup with INDEX MATCH formule depending on 2 conditions | Excel Worksheet Functions | |||
SUMPRODUCT or INDEX/MATCH for multiple conditions and multiple rec | Excel Discussion (Misc queries) |