Previous Topic Next Topic

How to compare two different columns

Closed
ABACUS Posts 1 Registration date Sunday July 21, 2013 Status Member Last seen July 21, 2013 - Jul 21, 2013 at 09:34 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - Jul 23, 2013 at 11:40 AM
Hi,

I have a sheet with Id numbers in column A and names in column B, for around 50 workers. In other sheet I have Id number in column A, names in column B, bank name in column C and bank number in column D, for 120 workers. Neither sheet1 and sheet2 are sort in any order. My question is: how can I get data from sheet2 column C and D next to the data in sheet1 in the easiest and fastest way.

Thanx
Related:

1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 555
Jul 23, 2013 at 11:40 AM
Hi Abacus,

Sort your data (at least sheet 2) and use VLOOKUP function.

Best regards,
Trowa

Similar discussions

Macro to compare sheets(Jan & Feb), highlight the difference, copy the comme
drsuresh26 -
ac3mark -

1 response
compare and count
vinod -
pcsces -

1 response
Compare Fields
Swapnil Arjun Veer -
Mazzaropi -

1 response
How to Compare two workbooks and see if data has moved or not?
hoosier1851 -
TrowaD -

1 response
Opening a word document in multiple versions
elizas -
closeup22 -

1 response