Dear Forum.
Not meaning to be 'milking it' by two posts on the one day but I got myself in much deeper than I originally anticipated and am now under pressure to make my workbook work shortly.
The attached workbook is a simplified example of what I’m looking to do.
In Cells D24:D32 I have array formula so that only the categories for the ‘desired house’ show up . The ‘desired house’ to be analysed is determined by the user selecting from the dropdown in Cell B23.
What I’m looking for is a solution in Cells E24:E32 that will display the correct quantity for the given category (based on looking at corresponding values in J2:V10). Since the categories displayed are going to change in D24:D32 as well as B23 depending on the ‘house’ that is being analysed I’m at a bit of a loss.
Any help would be great!!
Bookmarks