excel - Prices based on quarter returned -

i using table below pricing individual using excel. using formula below see today's date , month , give quarter month in. information on sheet one. formula,

=roundup(month(today())/3,0) 

, returns quarter in. know if match number retuned can match number above month range , pick price. changed automatically.

    table 1          | |price     sudtent | ac   | pricr      sudtent | mc   | pricr          table 2                               |           2     |        3       |       4     |  1                       | from|   april june |   july sept |  oct dec |jan march                         student | ac  |          130    |       97.50    |     65.00   |  162.50                 student | mc  |      180        |     135.00     |   90.00     |   225.00    

to quarter (e.g. ³⁄₁₂ of year) divide 4, not 3.

=roundup(month(today())/4, 0) 'alternate =ceiling(month(today())/4, 1) 

an index/match function pair can provide return pricing data matrix if supply both row_number , column_number parameters of index lookup.

in c3 as,

=index(d$9:g$99, aggregate(15, 6, row($1:$91)/((b$9:b$99=a3)*(c$9:c$99=b3)), 1), match(ceiling(month(today())/4, 1), $d$7:$g$7, 0)) 

fill down necessary.