Hi all,

I have two worksheets in the same workbook


The first screenshot is Worksheet A

3A.png

The second screenshot is Worksheet B

4A.png


Question: How to match SIZE PERCENTAGES numbers according to the columns “Line”, “Sub-Line”, “Category”, “Sub-Category”, “Occasion” and “Size Pack”?

For example, Worksheet A Column “S1” J10 cell value should be 18%, following the tabular data demarcated in red borders in both Worksheets A and B.

Many thanks!