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

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
 
T

T. Valko

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Search two columns in list for first and last name and return Id 4
Match like cells and return the latest date 1
How to separate user name and domain name in email id? 2
Display index of column headers in column A 9
Having Blank Cells, etc. ? 1
Complex Match 3
Setting up macro betwen two sheets 1
VLookUp or other function to return matched data from multiple col 7

Top