Combining data from 2 worksheets

Closed
kmac - May 3, 2010 at 12:11 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 3, 2010 at 12:21 PM
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 January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 3, 2010 at 12:21 PM
You can use VLOOKUP
kind of same as is being done here
https://ccm.net/forum/affich-337356-vlookup-formula
0