G
Guest
I have a spreadsheet with the following:
CompanyA Account# Amount
CompanyB Account# Amount
CompanyC Account# Amount
I would like to use the above spreadsheet to update another spreadsheet
organized as follows:
Company Account 1 Account 2 Account3 (Heading)
CompanyA Amount1 Amount2 Amount3
CompanyB Amount1 Amount2 Amount3
CompanyC Amount1 Amount2 Amount3
I'm not sure how to reference both the Company and the Account to return the
Amount.
Any assistance greatly appreciated.
CompanyA Account# Amount
CompanyB Account# Amount
CompanyC Account# Amount
I would like to use the above spreadsheet to update another spreadsheet
organized as follows:
Company Account 1 Account 2 Account3 (Heading)
CompanyA Amount1 Amount2 Amount3
CompanyB Amount1 Amount2 Amount3
CompanyC Amount1 Amount2 Amount3
I'm not sure how to reference both the Company and the Account to return the
Amount.
Any assistance greatly appreciated.