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.
Help Article Resources
Check out the Formula Handbook template!