Multiple Rows
Hello,
I have companies listed in one sheet (Main), and multiple contract numbers for each of these companies in another sheet. Is there a formula to match the contract numbers from the one sheet and add then to a new column in the Main sheet? The main sheet currently only has one line per company (parent), so I would need the formula to add rows (children) and note the contract number for each.
TIA!
Answers
-
Hi @Deborah Tzuberi ,
Will a report meet your need? Create a report from both sheets. Group by company. Contracts should appear below. You will need to use the same column names for the same data in both sheets.
Work?
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!