Board index MS EXCEL

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

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

Post by Sm9sYW50Y » Wed, 11 Mar 2009 04:16:06


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
 
 
 
Top

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

Post by T. Valk » Wed, 11 Mar 2009 06:35:48

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

 
 
 
Top

1. match row, then match column, then get header for that column?

2. The column prefix 'column name' does not match with a table name

3. Compare cells in column A ("ID") to column A ("ID)in two differen.

4. Issues List - ID column versus Issue ID column

5. Match attribute values (columns) to column names

6. Parent Columns and Child Columns don't have type-matching columns

7. Return text in Column A if Column B and Column K match

8. PWA Task ID doesn't match Project Task ID

9. Lookup ID/Problems with IDs not matching up

10. formula to match a range(sort) so it matches an external column

11. comparing numbers in two columns matching them and showing the ones that dont match

12. LOOKUP, MATCH MORE MATCHES IN TWO COLUMN

13. Match 2 Columns, Return 3rd, Differing Match Types

14. Match formula to match values in multiple columns

15. If two criteria match then sum matching values in another column

All times are UTC
Board index