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.
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...