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

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

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

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

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