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
|