Aug 06 2019 02:48 AM
Hi,
I have been having a lot of trouble trying to figure out something that I require for a model that I am building.
The model is for calculating the cost of renovating a house based on a standardised list of inputs that I have. I have a large master list of inputs that will be constantly updated, shown below.
I also have another sheet which will act as a template for a room. I want to be able to type the room in cell A1 'Kitchen' on the template sheet, and have it pull, from the master sheet, every input that could possibly go into renovating a kitchen. Now I have all the data in the correct sheet I can do some calculations to work out total cost (this is unimportant for the sake of this question.
In summary, I want to have a sheet for each room which will populate a certain section of a list based on whichever room I have typed in cell A1.
I can only think about doing some sort of long IF function combined with INDEX(MATCH)) but was looking for some sort of more concise method.
Aug 06 2019 03:24 AM
If you have the Monthly Channel version of Excel 365 then Dynamic Arrays and the Filter Function would be perfect
https://techcommunity.microsoft.com/t5/Excel-Blog/Excel-Dynamic-Array-Improvements/ba-p/332070
Aug 06 2019 10:16 AM