| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup when there is multiple same numbers
I am trying to extract names from a column that have the same team numbers.
NAMES TEAM# jeff 1 jay 2 tom 3 jim 1 dave 2 rick 3 I want to lookup team 1 then extract all 3 names on that team. Then I want to do the same for all the teams. A vlookup just returns the first number. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
lookup when there is multiple same numbers
See the post that is 2 posts below yours. It's titled: "If or similar but
true....." There are 2 different solutions in that thread that will do what you want. Biff "JPreeshl" wrote in message ... I am trying to extract names from a column that have the same team numbers. NAMES TEAM# jeff 1 jay 2 tom 3 jim 1 dave 2 rick 3 I want to lookup team 1 then extract all 3 names on that team. Then I want to do the same for all the teams. A vlookup just returns the first number. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup multiple values return one value corresponding value Excel | Excel Worksheet Functions | |||
| BIFF - Help!! lookup numbers in multiple columns and return one nu | Excel Worksheet Functions | |||
| vLookup with multiple lookup value in table array | Excel Worksheet Functions | |||
| Lookup in Multiple Columns, Return Multiple Values | Excel Worksheet Functions | |||
| Return Multiple Results with Lookup | Excel Worksheet Functions | |||
Linear Mode
