Hello,
I'm looking for a formula that can help me figure out number for item detail level from category standpoint. For example, in the category sheet has total number per category and per month and in the item detail sheet has a list of item number with category. I want a formula to recognize which item belongs to which category then use the total number of category by month to multiply with % of total in column D from Item Detail Spreadsheet. I attached the sample and hope you understand what I'm trying to achieve. Please advise the expected result spreadsheet.Test Book.xlsx
Thanks
Bookmarks