Index/Match Function returning Unparseable

Wyckstandt

Hi Team, I am attempting to pull in dates from a Project schedule into a Program plan across 2 smartsheets. I have used several variations of Index Match with no success. My key indicator is a unique number in both sheets.

Exp: I would like have the formula return the funding approved date from the project schedule into the Program Plan. This formula would then be copied down to the rest of the unique numbers in the list to pull in all of the dates from the project schedule for funding.

INDEX - Funding date from the project schedule

MATCH - Unique number from the Program Plan and the Project Plan Funding Column Date.

=INDEX({Funding approved date column in project schedule}; MATCH(Unique number@row; {Project Plan funding column}; 0))

Really lost on how to make this one work. Any help would be so greatly appreciated.

Darren Mullen

@Wyckstandt

for column names with spaces, you need to enclose them in brackets [] like this

See the [Unique number] column

=INDEX({Funding approved date column in project schedule}; MATCH([Unique number]@row; {Project Plan funding column}; 0))

Wyckstandt

Thank you so much Darren that worked!