how to lookup a value and return multiple corresponding values

[Guest]

how do i look up a value from a list and return multiple corresponding
values? In addtion, i want to have the corresponding values for the
subsequent colums.

Thanks.

 

[Bob Phillips]

Here is a formula that should do it. Put this in the first of the target
cells and copy down

=IF(ISERROR(SMALL(IF($A$1:$A$20="Bob",ROW($A$1:$A$20),""),ROW(A1))),"",INDEX
(B$1:$B$20,SMALL(IF($A$1:$A$20="Bob",ROW($A$1:$A$20),""),ROW(A1))))

it is an array formula, so commit with Ctrl-Shift-Enter.

Change column B for the other columns

--

HTH

RP
(remove nothere from the email address if mailing direct)