• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 247
  • Last Modified:

Compare 2 excel sheets and copy content next to it.

Hi,

I have 2 excel sheets. Both have the Emp id's identical but can be in a scattered manner and in Colum A in each sheet.
What i want to do is Excel B should search for the emp id in Excel A and copy all the contents next to it
In excel A i have
Emp id,Age,Name and in excel B i have seat no and county.
I want to combine them to one sheet.

Regards
Sharath
0
bsharath
Asked:
bsharath
  • 3
1 Solution
 
patrickabCommented:
Sharath,

Here's a file using VLOOKUP() to assemble the data:

http://my.storenow.net?f=1675

Hope that helps

Patrick
0
 
bsharathAuthor Commented:
Can you tell me what happens in the file you posted please.
0
 
patrickabCommented:
=VLOOKUP($A2,'Excel A'!$A$2:$C$10000,2,FALSE)

The reads as "Lookup the value in A2 and find it in the first column of the range 'Excel A'!$A$2:$C$10000, and when found return the value on that row but in the second column of that range (in this case column B). The FALSE means return a value only if there is an exact match and it also allows the VLOOUP to work if the values in the range 'Excel A'!$A$2:$C$10000 when they are not not sorted."

Same idea for the other column.

Hope that helps
0
 
patrickabCommented:
Sharath - Thanks for the grade - Patrick
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now