I am trying to make a spreadsheet in Excel that will display multiple rows and columns if an IF statement is true. For example, we are making a machine that has different zones, and different parts associated with each zone. So if one machine has 10 zones, I want a list of coordinating part numbers, quantities and part descriptions to show up. If I choose a machine with 15 zones, I want the corresponding information to show up for that. Is this possible?
