| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding a number in a column out of an array in another column
I have two columns of company IDs. One column is attached to the company
name, the other is attached to company leaders (individual people). I need to find a way to match up the company name to each individual. Any suggestions? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Finding a number in a column out of an array in another column
What does "attached" mean? Do you have 4 columns, 1 column of IDs with a
corresponding column of company names and then 1 column of IDs with a corresponding column of peoples names? Biff "cirena" wrote in message ... I have two columns of company IDs. One column is attached to the company name, the other is attached to company leaders (individual people). I need to find a way to match up the company name to each individual. Any suggestions? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Finding a number in a column out of an array in another column
That's exactly it. sorry I wasn't clear. So it looks like:
1 Joe Co. 1 Joe Smith 2 Biffco 1 Jane Smith 3 ACME 1 Jim Smith 4 LVCC 2 Max Musterman I need to have "Joe Co." on the same row as Jane Smith and Jim Smith. Thanks again for your help. "T. Valko" wrote: What does "attached" mean? Do you have 4 columns, 1 column of IDs with a corresponding column of company names and then 1 column of IDs with a corresponding column of peoples names? Biff "cirena" wrote in message ... I have two columns of company IDs. One column is attached to the company name, the other is attached to company leaders (individual people). I need to find a way to match up the company name to each individual. Any suggestions? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Finding a number in a column out of an array in another column
Assume:
A2:A5 = IDs B2:B5 = company names D2:D5 = IDs E2:E5 = names Enter this formula in F2 and copy down as needed: =VLOOKUP(D2,A$2:B$5,2,0) Biff "cirena" wrote in message ... That's exactly it. sorry I wasn't clear. So it looks like: 1 Joe Co. 1 Joe Smith 2 Biffco 1 Jane Smith 3 ACME 1 Jim Smith 4 LVCC 2 Max Musterman I need to have "Joe Co." on the same row as Jane Smith and Jim Smith. Thanks again for your help. "T. Valko" wrote: What does "attached" mean? Do you have 4 columns, 1 column of IDs with a corresponding column of company names and then 1 column of IDs with a corresponding column of peoples names? Biff "cirena" wrote in message ... I have two columns of company IDs. One column is attached to the company name, the other is attached to company leaders (individual people). I need to find a way to match up the company name to each individual. Any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding Number of cells in a column of other sheet having a specific word in them | New Users to Excel | |||
| Finding last receipt number in a column ? | Excel Worksheet Functions | |||
| Finding the closest number in column A and take the value in column B | Excel Worksheet Functions | |||
| Finding if a number is less than a setpoint in a column | Excel Discussion (Misc queries) | |||
| Finding the max of a column where values less than a specified number | Excel Worksheet Functions | |||
Hybrid Mode
