chrisguk
Board Regular
- Joined
- Jan 10, 2011
- Messages
- 135
Normally I have no problem trying to understand my own logic for a formula but this time I seem to of hit a brick wall:
This is what I am trying to achieve:
SHEET 1
<tbody>
</tbody>
<tbody>
</tbody>
EMPTY TABLE WITH FORMULAS
<tbody>
</tbody>
SHEET 2
<tbody>
</tbody>
So to populate the table in Sheet 1 I want to look in the whole of sheet 2 by stating list all items that match the criteria selected in the dropdown lists for example:
Select Jan 2016: It will therefore populate the table dynamically (expanding the rows) with data from sheet 2. I know I can achieve the same result with filters on sheet 2 but it was necessary for cosmetic reasons to have a separate sheet with this data.
I have tried to achieve this with IF(OR SUMIFS and VLOOKUP but seem to be going around in circles.
I would be very grateful if anyone is able to help me with this.
Many thanks
Chris
This is what I am trying to achieve:
SHEET 1
DROPDOWN LIST WITH MONTHS (CELL A1) |
<tbody>
</tbody>
DROPDOWN LIST WITH YEARS (CELL B1) |
<tbody>
</tbody>
EMPTY TABLE WITH FORMULAS
A1 | B1 | C1 |
ITEM | Price | Qty |
<tbody>
</tbody>
SHEET 2
A1 | B1 | C1 | D1 | E1 |
ITEM | Price | Qty | Month | Year |
Brush | 2.00 | 3 | Jan | 2016 |
Handle | 1.00 | 4 | Feb | 2016 |
Cloth | 1.00 | 1 | Jan | 2016 |
<tbody>
</tbody>
So to populate the table in Sheet 1 I want to look in the whole of sheet 2 by stating list all items that match the criteria selected in the dropdown lists for example:
Select Jan 2016: It will therefore populate the table dynamically (expanding the rows) with data from sheet 2. I know I can achieve the same result with filters on sheet 2 but it was necessary for cosmetic reasons to have a separate sheet with this data.
I have tried to achieve this with IF(OR SUMIFS and VLOOKUP but seem to be going around in circles.
I would be very grateful if anyone is able to help me with this.
Many thanks
Chris