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 |
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 |
All times are GMT +1. The time now is 07:44 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com