Returning multiple values

A

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?
 
A

Alan Beban

Anthony said:
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?
Click to expand...
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
 
Top