Multiple answers from vlookup
 

I've trawled through several answers for this but to no avail.

I have a list of names each of which has a division number adjacent to it. i.e. two columns, one names one numbers.

Lets say there are ten names and three divisions.

I would like to query this data and display, on a different 'division' sheet, all the names that are in a particular division.

I would then like to be able to add names to the bottom of the list that automatically appear on the correct divisions sheet.

Many thanks in advance for any help

--
Message posted via http://www.officekb.com

Multiple answers from vlookup
 

Hi
for extracting I would use 'Data - filter - Advanced Filter'

--
Regards
Frank Kabel
Frankfurt, Germany

"Hugh Woods Ballard via OfficeKB.com" schrieb im
Newsbeitrag ...
I've trawled through several answers for this but to no avail.

I have a list of names each of which has a division number adjacent
to it. i.e. two columns, one names one numbers.

Lets say there are ten names and three divisions.

I would like to query this data and display, on a different
'division' sheet, all the names that are in a particular division.

I would then like to be able to add names to the bottom of the list
that automatically appear on the correct divisions sheet.

Many thanks in advance for any help

--
Message posted via http://www.officekb.com