Lookup or Loop Through?

Hi there.

A picture is worth 1,000 words. An Excel sheet is worth 1,000 pictures.

Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet.

ALso... please update your profile, unless you are still using Excel 2003. If you are still using it, say so when adding your file, so I know you actually read this!!

Hello cdc
Try pasting the following into cell C4 then dragging the fill handle over to cell BL4 and then, while C4:BL4 are still selected, down to cell BL7:

Formula:

=IFERROR(LEFT(INDEX(Input!$C$2:$C$4,AGGREGATE(15,6,(ROW($C$2:$C$4)-ROW($C$1))/(Input!$E$2:$E$4=C$2)/(Input!$A$2:$A$4=$A4),1)),3),"")

Let us know if you have any questions.