Index match formula for the month
Hi Everyone
I have two sheets here "Intake" & "CalRef".
On the intake sheet i have the column - Date month funded month Nr which return the number month from the column - Date funded. Now i want the use the formula:
=IFERROR(INDEX({CalRef Range - Month Name}; MATCH([Date funded Month Nr]@row; {CalRef Range - Month Nr}; 0)); "")
to return the Month Name from another sheet( CalRef).
Can someone explain why the index match formula returns a blank? just want to know the reason.
Pics…
Intake sheet
CalRef sheet
I have used the below formula and it works fine
=IF([Date funded Month Nr]@row = 1; "January"; IF([Date funded Month Nr]@row = 2; "February"; IF([Date funded Month Nr]@row = 3; "March"; IF([Date funded Month Nr]@row = 4; "April"; IF([Date funded Month Nr]@row = 5; "May"; IF([Date funded Month Nr]@row = 6; "June"; IF([Date funded Month Nr]@row = 7; "July"; IF([Date funded Month Nr]@row = 8; "August"; IF([Date funded Month Nr]@row = 9; "September"; IF([Date funded Month Nr]@row = 10; "October"; IF([Date funded Month Nr]@row = 11; "November"; IF([Date funded Month Nr]@row = 12; "December"))))))))))))
Answers
-
It looks like the formula in the intake sheet is outputting text values. What formula are you using there?
-
The formula for Date Funded Month Nr?
This is the formula….
=IFERROR(UPPER(MONTH([Date funded]@row)); "")
-
Try getting rid of the UPPER function. It is converting it into a text string that only looks like a number.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!