Hi all,
I have two worksheets in the same workbook
This is Worksheet A
1A.png
This is Worksheet B
2A.png
I would like to match the corresponding quantity to the corresponding grade in Worksheet A based on the Columns "Line", "Sub-Line", "Category", "Occasion", "Sub-Cat" and "Grade" in Worksheet B.
Question: How to get the corresponding quantity?
Many thanks!
Bookmarks