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!!