Tracking Expenses While Sorting

What are the 8 numbers referring to at the end of this formula? =LOOKUP(MONTH(F18),{1,4,7,10},{2,3,4,1})

They are the lookup_vector and [result_vector].

LOOKUP(lookup_value, lookup_vector, [result_vector])

LOOKUP finds the nearest match less than or equal to the number that MONTH returns. It then finds the value in the [result_vector] (quarter) corresponding to that match.

Since the 1st quarter begins in Oct (10th month) one is assigned the last position in the [result_vector] (the quarters). The others correspond accordingly.

Did that help?

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.