Comparing 2 worksheets

B

Ben Watts

I have a bunch of data on sheet 1, on sheet two I have similar data. I want
to match data in column W in sheet 1 to data in column BN in sheet 2. When
there is an exact match I want all the data on that row in sheet 2 to be
returned to the row in sheet 1 where those cells matched. I know this is
confusing.

Sheet 1
A B C D E
7777 8888 9999 0000 0110
Sheet 2
1111 2222 3333 4444 0110
So in otherwords, where column E matches here I want it returned to sheet
one to look like this:

7777 8888 9999 0000 0110 1111 2222 3333 4444 0110

Hope that explains it. The columns I use are in the first paragraph!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top