Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup returning multiple answers | Excel Worksheet Functions | |||
How do I only get valid "answers" in a VLOOKUP function (no #N/A's | Excel Worksheet Functions | |||
VLOOKUP-How do I get answers pulled from different appropriate col | Excel Worksheet Functions | |||
Can VLOOKUP return multiple answers based on several identical lo. | Excel Worksheet Functions | |||
Vlookup with multiple answers | Excel Programming |