Quote:
Originally Posted by Claus Busch
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