how to match matched ID and name columns to organized ID column

  • Thread starter Thread starter Jolanta
  • Start date Start date
J

Jolanta

I have two columns: column A with ID and column B with matching names. There
is third column C with IDs, which are identical like in column A, but
organized into groups and IDs are many times repeated. I want to find the way
of matching names in column B to the column C.
Is there any way?

Any suggestion would help
regards
Jolanta
 
A1:A5 = IDs
B1:B5 = names
C1:C15 = IDs

Enter this formula in D1 and copy down to D15:

=INDEX(B$1:B$5,MATCH(C1,A$1:A$5,0))
 
Back
Top