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

Visio 2010 - Organization Chart Wizard - Hebrew Excel Database 0
Find value based on two lookup values 2
Index/match across multiple columns? 16
Matching data in columns 1
Grouping Names in Mail Merge 0
Search two columns in list for first and last name and return Id 5
Word VBA - Want to test if Full Name is NOT Present in document 0
Highlight every 5th recurrence in a column for a given value/id 1

Top