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!
Bookmarks