Index to equal exact matches
I created a formula that should look for a specific cell within a range from another sheet, and report back another column. However, it does not search an exact match.
Formula: =INDEX({Res Sales Metrics Month}, MATCH([Date2]@row, {Res Sales Metrics Year-Month}), 0)
I want my month name column to report back the actual month name.
The sheet it is referencing is:
What is happening, is that if any "Date2" is matched with just '2018 / 1*", it pulls the first option, which is January.
Any ideas how i can make my index be an exact match before it pulls back an answer?
Best Answer
-
Wow..... Finally figured it out....
Here was my formula i was having countless hours of problems on:
=INDEX({Res Sales Metrics Month}, MATCH([Date2]@row, {Res Sales Metrics Year-Month}), 0)
Here's the formula working great!:
=INDEX({Res Sales Metrics Quota}, MATCH([Date2]@row, {Res Sales Metrics Year-Month}, 0))
Yes - it was the placement of a ")"..... Hours gone.....
Answers
-
Wow..... Finally figured it out....
Here was my formula i was having countless hours of problems on:
=INDEX({Res Sales Metrics Month}, MATCH([Date2]@row, {Res Sales Metrics Year-Month}), 0)
Here's the formula working great!:
=INDEX({Res Sales Metrics Quota}, MATCH([Date2]@row, {Res Sales Metrics Year-Month}, 0))
Yes - it was the placement of a ")"..... Hours gone.....
-
Glad you sorted it out!
Placement of parentheses can definitely be tricky, and easy to miss. The default for MATCH without an indicator (like the 0 in the right place) is 1 (see here for more information).
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Thank you for sharing🤸♀️! I was having headaches for two hours straight!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!