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 January 16, 2023 - 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

How to compare two different columns
Beyond compare download - Download - File management
Display two columns in data validation list but return only one - Guide
Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Excel Forum
How to compare two Excel sheets with varying data ✓ - Excel Forum
How to compare two columns in excel for partial matches - Guide

1 response

Answer 1 / 1

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 549
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

Comparing columns and returning value

Comparing Two Excel Sheets and copying like data to third sheet

Extract identical cells of 2 columns (excel)

Macro to compare 2 sheets and copy differences

VBA Compare 2 sheets and output difference to 3rd sheet

Similar discussions

Subscribe To Our Newsletter!