Hello all,
I am getting a workbook ready. The first tab will be a summary of the rest of the book.
The other tab will contain all the data for each product as shown below roughly.
<tbody>
</tbody>
Now I have named each row and column on that table and tried to use the INDEX function to return the value in the summary tab. My formula was {=INDEX(table_name,Product_Category_1,Av_GP)}
But that's obviously not working. The trouble is that extra rows will be added when new products are added and therefore messing up the summary.
What is the best way to achieve it without naming each cell individually?
I am getting a workbook ready. The first tab will be a summary of the rest of the book.
The other tab will contain all the data for each product as shown below roughly.
| Av GP% | Av Cash Margin | Nb Item/Category | ||
| Product Category_1 | ||||
| Products_1 | ||||
| Products_2 | ||||
| Product Category_2 | ||||
| Products_3 | ||||
| Products_4 | ||||
| Product Category_3 | ||||
| Products_5 | ||||
| Products_6 |
<tbody>
</tbody>
Now I have named each row and column on that table and tried to use the INDEX function to return the value in the summary tab. My formula was {=INDEX(table_name,Product_Category_1,Av_GP)}
But that's obviously not working. The trouble is that extra rows will be added when new products are added and therefore messing up the summary.
What is the best way to achieve it without naming each cell individually?
