Returning multiple values

[Anthony Slater]

Hi

Sheet 2 A1:A200 contains surnames
Sheet 2 B1:B200 contains first names

I would like to type in a particular surname (Smith for
example) and get a list of all the first names related to
the surname returned in a seperate column

Any ideas?

 

[Don Guillett]

Why not just use data>filter>autofilter. Record a macro and modify to re-use

 

[Alan Beban]

Hi

Sheet 2 A1:A200 contains surnames
Sheet 2 B1:B200 contains first names

I would like to type in a particular surname (Smith for
example) and get a list of all the first names related to
the surname returned in a seperate column

Any ideas?

If the functions in the freely downloadable file at
http://home.pacbell.net/beban are available to your workbook

=VLOOKUPS("Smith", A1:B200, 2) array entered into a column of cells of a
number equal to at least the number of occurrences of Smith. If too many
cells are selected, the extras will be blank; if too few are selected, a
message will be returned indicting the minimum number of cells to be
selected.

Alan Beban