Ask a question
Report

# How to match two columns [Solved/Closed]

Paris - Latest answer on Aug 30, 2010 03:27AM

Hello,

I have 2 excel sheets with exactly the same format, in column A, I have the name of my customers and in Column B, the value of their sales. the other sheet contains exactly the same information but not in the same order. Now what I want to do is : If the name of my first customer (A1,sheet1) exists in the A column of sheet 2 then bring the sales value to cell C1 of the first sheet.

Sheet 1 ------------------ Sheet 2

A --------- B ---------------- A ------ B

X --------- 500 ---------------- Y ------- 540

Y -------- 1000 ---------------- Z ------- 100

Z -------- 200 ----------------- X ------- 800

And I need the result as this :

A -------- B -------- C

X -------- 500 -------- 800

Y -------- 1000 -------- 540

Z -------- 200 -------- 100

I have 2 excel sheets with exactly the same format, in column A, I have the name of my customers and in Column B, the value of their sales. the other sheet contains exactly the same information but not in the same order. Now what I want to do is : If the name of my first customer (A1,sheet1) exists in the A column of sheet 2 then bring the sales value to cell C1 of the first sheet.

Sheet 1 ------------------ Sheet 2

A --------- B ---------------- A ------ B

X --------- 500 ---------------- Y ------- 540

Y -------- 1000 ---------------- Z ------- 100

Z -------- 200 ----------------- X ------- 800

And I need the result as this :

A -------- B -------- C

X -------- 500 -------- 800

Y -------- 1000 -------- 540

Z -------- 200 -------- 100

Read more

hai- Jul 15, 2009 05:36AMtra- Jun 22, 2010 05:41AM