| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to match matched ID and name columns to organized ID column
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to match matched ID and name columns to organized ID column
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sorting matched columns | Excel Discussion (Misc queries) | |||
| Need to match 2 columns, if a match found add info from 2nd column | Excel Worksheet Functions | |||
| Return Title to matched column | New Users to Excel | |||
| Copying matched criteria plus relevant columns to new worksheet | Excel Discussion (Misc queries) | |||
| Using Excel's XML mapping/export with data organized in columns | Excel Worksheet Functions | |||
![Jolanta[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
