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

See more
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

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