Get the column or collection index of a Matched value
In the example below I am trying to get the array index of the matched value. I'm looking for the number in columns Jan - Dec where it equals the value in Current Month. I can find the value, but I need the position so I can derive the financial period the entry falls into.
Or better yet, how would I get the position of the last populated column?
Help Article Resources
Check out the Formula Handbook template!