How do I use the INDEX & MATCH function when trying to pull information from one sheet into another?

Ameena Bossier

Hey All,

Reaching out to the masses to hopefully get some help. I need to pull information from sheet 1 into sheet 2 using the INDEX  and MATCH functions.

Sheet 1 that I want to pull information from has:

• Child rows
• Task Name column (The list of tasks have the same name in both sheet 1 and sheet 2)
• Actual Date column

What I want to show up in sheet 2

• The Actual Date column information

I’ve tried the following and keep getting “UNPARSABLE”, blank cells, or “NO MATCH” as the result

• =INDEX({Actual Date}, MATCH([Exercise Name]@row, {Exercise Name}))
• =INDEX([Actual Date]:[Actual Date], MATCH(Exercise Name@row, [Task Name]:[Task Name], 0))
• =INDEX({Actual Date}, MATCH([Exercise Date]@row, {Exercise Name}))
• =INDEX([{Actual Date}]:[{Actual Date}], MATCH([Exercise Name]@row), [{Exercise Name}]:[{Exercise Name}], 0))
• =INDEX({Exercise Name}, MATCH([Exercise Name]@row, {Actual Date}))

I’ve gotten this info from Smartsheet

• Combining INDEX and MATCH in the same formula you will be able to pull up text value as well as numeric values. The INDEX function will be used as the reference of the column of the value to return whereas the MATCH function will be looking at the value to match it with.
• An example of the formula would look similar to the following: =INDEX({Column with value to return}, MATCH([Value to match]@row, {Column with value to match in the other sheet}))
• https://help.smartsheet.com/function/index
• https://help.smartsheet.com/function/match
• https://help.smartsheet.com/function/children

I can’t figure out what I’m missing! HELP PLEASE! :)

Ameena Bossier

@Andrée Starå - Apologies for the overdue response! Your solution worked! I also found that I need to make sure the column properties were the on both sheets. That will lead to an error if they aren't.

Thanks again! :)

-Ameena