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?

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?

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?

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?