I have a template that I use for budgeting expenses. Some expenses are spread
using a simple straightline method or based on the number of days in a month.
Some expenses are spread based on the percentage of the months sales to total
sales or as a % of those revenues. I am currently using a table that has the
methods/values by month and I reference the table using the index function
embedded within a conditional
[=IF($X22="",0,IF(AND($Q22="Variable",$X222),INDEX (tble,$X22,AA$2)*$R22,IF($X222,INDEX(tble,$X22,AA $2)/INDEX(tble,$X22,13)*$T22)))].
In this formula tble is the table of values

Does anyone have any thoughts on how to accomplish this using an array
formula?