Formula with multi-cell answers

**FrznWltDsny** · 04-15-2007, 05:31 PM

Hello!

IF(C3=E24:E100,D24:D100,A1)

Simple if then formula, however, I have multiple answers. I was wondering if I could get all of the answers to be displayed over the same amount of cells... Its for a program list for swimming class. The C3 = program number, E24:E100 = all program numbers, and D24:D100 = Names. Obviously with the above code I get a #value error. Since I can't have multiple answers. Is there a way to resolve this?

Thank you!

FrznWltDsny

**rylo** · 04-15-2007, 07:08 PM

Hi

In any column starting in row 1 (say F1) array enter (ctrl, shift, enter) the formula

=IF(ROW()>COUNTIF($E$24:$E$100,$C$3),"",INDEX($D$24:$D$100,SMALL(IF($E$24:$E$100=$C$3,ROW($E$24:$E$100)-23),ROW())))

Copy and paste down as required.

HTH

rylo

**starguy** · 04-16-2007, 08:07 AM

Originally Posted by FrznWltDsny

Hello!

IF(C3=E24:E100,D24:D100,A1)

Simple if then formula, however, I have multiple answers. I was wondering if I could get all of the answers to be displayed over the same amount of cells... Its for a program list for swimming class. The C3 = program number, E24:E100 = all program numbers, and D24:D100 = Names. Obviously with the above code I get a #value error. Since I can't have multiple answers. Is there a way to resolve this?

Thank you!

FrznWltDsny

see the attached file.