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 Moderator Last seen December 27, 2022 - Jul 23, 2013 at 11:40 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator 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
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:
- How to compare two different columns
- Display two columns in data validation list but return only one - Guide
- Tweetdeck larger columns - Guide
- Beyond compare - Download - File management
- How to delete columns in word - Guide
- Excel compare two sheets - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Jul 23, 2013 at 11:40 AM
Jul 23, 2013 at 11:40 AM
Hi Abacus,
Sort your data (at least sheet 2) and use VLOOKUP function.
Best regards,
Trowa
Sort your data (at least sheet 2) and use VLOOKUP function.
Best regards,
Trowa