Function that looks up a value under each subcategory
Hope you are well
I was wondering if you can maybe help me find a function that will solve my problem.
In my one sheet my expenses are categorized, and under each category is then subcategorized according to the months. I would like to link/look up these values on a different sheet. My problem is that it needs to get the value for March for example and then look up each category's March value to the appropriate category. Why I think something like a VLOOKUP won’t work is because in my description column there will be multiple names for each month. I hope I am making sense.
Description Feb Mar April
Steel X Y Z
Wages A B C
I need sheet 2 to read each month’s value from sheet 1 without having to do a cell link as the number of cells is a lot.
Please let me know if you can maybe help me.
Help Article Resources
Check out the Formula Handbook template!