I'm looking to replace offset with non-volatile functions. I use it in sumif formulas to find the column or row to sum, for example,
=sumif(A:A,"yes",offset(A:A,0,match(1:1,"December",0)-1))
Index works okay if I am looking for a row, but what can I use if I am looking for a column like the above formula?
Thanks
Bookmarks