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

Index match formula with multiple conditions
 

Hi,

Am Tue, 27 May 2014 07:52:28 +0100 schrieb GijsKijlstra:

{=INDEX(F$2:F$98,MATCH(1,($A$2:$A$98=$A103)*($C$2: $C$98=$C103),0))}

you better had attached an excel file instead a picture.

Try:
=IFERROR(INDEX($F$2:$F$98,SMALL(IF(($A$2:$A$98=$A$ 103)*($C$2:$C$98=$C$103),ROW($1:$97)),ROW(A1))),"" )
and enter the array formula with CTRL+Shift+Enter and copy down till the
cells remain empty.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

Hi Claus,

Thank you very much for your fast response.

I would have loved to include my xlsx, regrettably ExcelBanter doesn't allow me to attach an xlsx; only zip files, my MacBook wouldn't be able to create.

I have meanwhile copied your formula in my sheet (CTRL+Shift+Enter), but I still get a zero value, whilst I should have a number.

Do you have an alternative or a suggestion how to get the xlsx to you?

Thanks again for your fast response and with kind regards,
Gijs

Index match formula with multiple conditions
 

Hi,

Am Tue, 27 May 2014 10:56:18 +0100 schrieb GijsKijlstra:

Do you have an alternative or a suggestion how to get the xlsx to you?

send it to my email address


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

Index match formula with multiple conditions
 

Hi again,

Am Tue, 27 May 2014 12:58:44 +0200 schrieb Claus Busch:

send it to my email address

I just checked Excelbanter and saw that there is no address shown.
Send it to claus_busch(at)t-online.de


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

Index match formula with multiple conditions
 

Hi again,

Am Tue, 27 May 2014 12:58:44 +0200 schrieb Claus Busch:

send it to my email address

I just checked Excelbanter and saw that there is no address shown.
Send it to claus_busch(at)t-online.de


Regards
Claus B.

Claus,
I tried to email you but got a delivery failure notice!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

Index match formula with multiple conditions
 

I see the problem! I made a typo in your email address. Resending...

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion