Combining data from 2 worksheets

Closed
kmac - 3 May 2010 à 12:11
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 3 May 2010 à 12:21
I have 2 worksheets that I am working with. They have very similiar information, but what I would like to do is combine them. The common factor is the account number. I'd like to know if there is a way to bring all of the information from one worksheet and combine it with the second worksheet, matching them up by the column called, "Account". That is the only data that they have in common. Can someone help me with this?

Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
3 May 2010 à 12:21
You can use VLOOKUP
kind of same as is being done here
https://ccm.net/forum/affich-337356-vlookup-formula