Combining data from 2 worksheets [Closed]

Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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?

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
767
You can use VLOOKUP
kind of same as is being done here
https://ccm.net/forum/affich-337356-vlookup-formula

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!