Index Match not working

Amanda Bosley

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!

DKazatsky2

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