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: 2880
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: May 2, 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

How to compare two different columns
Compare mutliple Excel columns ✓ - Forum - Excel
Compare two excel Columns of differant size ✓ - Forum - Excel
Compare two excel columns for missing values - Forum - Excel
Compare two columns in excel for partial matches - Guide
Excel - Compare column A & B give results in column C - How-To - Excel

1 reply

Answer 1 / 1

TrowaD

Posts: 2880
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: May 2, 2022

509
Jul 23, 2013 at 11:40 AM

Hi Abacus,

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

Best regards,
Trowa

Subscribe To Our Newsletter!