Compare Copy Paste

[josieguida02]

I am trying create and Excel Formula. To compare columns of names and then copy a number in a column next to the correct name.

More info

Column A = Actor ID
Column B = Actor
Column H, K, N, Q, T, W, Z = Actor
Column G, J, M, P, S, V, Y = Actor ID (This is the column that I want a copy of the Actor ID to be placed)

Example

In column B there is a name Hugh Grant the Actor ID Column A is 1120
In coumn H there is an Actor Hugh Grant and I want the Actor ID to go in G as 1120 next to Hugh Grant in column H.

A B G H
1120 Hugh Grant Hugh Grant

How to fill in column G With the data from column A, in this case 1120?

 

[PKTEE]

Dear josieguida02,

Assumed your data Actor ID is start at A1.

Use the following formula in G1 ( Next to H1 which is Hugh Grant)
=INDEX(A2:A15,MATCH(H1,B2:B15,0))


Hope it help..

 

[josieguida02]

Thank you for your help. I will try and clarify a bit more. Sorry about the confusion.

Column A is the list of numbers, 1 through 2984, that are associated with the list of alphabetized actors in Column B.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
Columns H, K, N, Q, T, W, Z are lists of actor names that are random in order.<o></o>
<o> </o>
I am trying to match the random lists with the ordered list. I want to put the associated number from the alphabetized lists in columns G, J, M, P, S, V, Y. <o></o>

 

[josieguida02]

I forgot to add.

The lists of random actors is 1312 long.

 

[josieguida02]

Thank you very much for you help.

This is what I ended up using in the end.
=INDEX(A:A,MATCH(H1,B:B,0))

It got around the problem of the A and B numbers changing when i copied and pasted the formula through the cells. I only needed the H number to change


Most excellent.

 

[PKTEE]

Glad you manage to find an answer.