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

--
Biff
Microsoft Excel MVP


"Jolanta" wrote in message
...
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