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?
Thank you,
Answers
-
The MATCH function would output the column number where the value in [Current Month] is located in the Jan - Dec columns.
=MATCH([Current Month]@row, January@row:Dec@row, 0)
-
I thought that would work too, but I got NO MATCH when trying that...
I just found be clicking on a Current Month cell that there is a hidden ` character in front of the value. I think the import process put that there. Also found that the column was set to drop down instead of plain text.
After changing the column to plain text, the formula worked....
** Is there a way to find the last match in case there are duplicate entries? **
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 207 Use Cases
- 517 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 83 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!