matching 2 columns

**madmega** · 04-20-2012, 08:32 AM

Hi, i am searching on google all morning for this.
I have one excell file, it has 23 rows.
Row A and B are from another excel file and contain data that is synchronized.
Row C has the same numbers as row A but is not matching/synchronized BUT the data from row C til row W is synchronized alltogether, so that has to stay that way.
What i am looking for is a way to have row A with the synchronized row B, matching with rowC.
Because i need the data in row B to be synchronized with row C...how can i do that.
Row A has 11140 entries and row C has 8097 entries.
So, I want to match row A with row C but in the process also row B, row B is matched/synced to row A, and when row A matches with C, it still has to match with row A...and than remove the cells from A and B, that do not match.
if someone wants a example than please reply

**Søren Larsen** · 04-20-2012, 09:51 AM

Without a sample spreadsheet containing data and a before/after scenario this is gibberish to me...?

**madmega** · 04-20-2012, 09:58 AM

Hope this works.
2ONS.xlsx

**Søren Larsen** · 04-20-2012, 10:06 AM

I created a new list containing all unique values from A and C, and then used =INDEX(MATCH()) to connect B and D to this new list. Is that what you need?

**madmega** · 04-20-2012, 10:22 AM

Thank you, but i do not understand it.
Column A and column C are already matching till number 687, i do not know how to match the rest, i am studying your file but i do not think i understand if it is how i explained it to be.

But i can work with this list, i am almost done, THANK YOU !!!