LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
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知 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
Attached Images
 
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Return value with 2 conditions (using Lookup/Match/Index) Venice Excel Discussion (Misc queries) 3 April 3rd 09 04:26 PM
VLOOKUP MATCH INDEX two conditions / criterias text and date John Excel Worksheet Functions 7 September 10th 08 11:31 AM
index(match) Wind Uplift Calculations (match four conditions) JMeier Excel Worksheet Functions 8 August 1st 08 01:45 AM
lookup with INDEX MATCH formule depending on 2 conditions Excel ESG Excel Worksheet Functions 6 June 7th 07 10:21 AM
SUMPRODUCT or INDEX/MATCH for multiple conditions and multiple rec TravisB Excel Discussion (Misc queries) 21 March 16th 07 09:49 PM


All times are GMT +1. The time now is 06:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ゥ2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"