I have a table with 8 items that we sell. Each item has a code, which corresponds to the applicable pricing sale we have for that item, over a span of 8 time periods.
I'm having trouble coming up with efficient formulas that will give me the answers that are in the orange-colored boxes.
pic2.PNG
This table has been simplified -- the true table I need formulas for has hundreds of various codes, and hundreds of periods, so simply doing a 8-step nested "if" statement won't really cut it in this particular project.
I've attached the workbook so you can play around in it. The values in orange are the correct values, and are the cells I need formulas for.
I appreciate any help I can get.
Bookmarks