Index Match not working
Hello -
I am trying to use a formula on sheet 1 to return a value from sheet 2 based on the matching of a task name. I have tried the below formula (in many adjusted forms) but cannot seem to get it to work correctly.
Some troubleshooting I have done:
- Set up references to search the entire columns of "Task Name" and "Actual Start Date"
- used the formula across multiple different rows in Sheet 1 to see if there was an issue with a specific task name
- add "IFERROR" function to the formula in case there are no matches
Below is the formula I was using and some screenshots of Sheet 1 and Sheet 2 for reference.
=INDEX({C2 2025 NIT/Kids Sportswear Range Actual End Date}, MATCH(Task@row, {C2 2025 NIT/Kids Sportswear Task Name}, 0))
Sheet 1: green shaded square is where the formula will go. I want the date to populate from the reference sheet
Sheet 2: I want the formula to reference Sheet 1 "Task@Row" and Sheet 2 "Task Name" and return the value when they match
Am I missing something? I feel like it will probably be obvious once I hear it but I am really stuck right now.
Thanks in advance for any help!
Answers
-
Hi @Amanda Bosley,
Can you share what results you are seeing? I have recreated your scenario and it is working as expected with the same exact formula.
Thanks,
Dave
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!