Previous Topic Next Topic

How to compare two different columns

Closed
ABACUS Posts 1 Registration date Sunday 21 July 2013 Status Member Last seen 21 July 2013 - 21 Jul 2013 à 09:34
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 23 Jul 2013 à 11:40
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

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

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

Best regards,
Trowa

Similar discussions

Convert number to spelling
Sukumar -
mrwagh85 -

28 responses
Match value in 2 separate columns and return a value from a 3rd
JD_Silver -
TrowaD -

1 response
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses