Multiple Rows

Deborah Tzuberi

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!

Mark Cronk

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