Best way to pull data

Shahara Anderson

Hello,

I have a Master list detailing different department projects, and I use a template to create each project. I want to search the master and return information to the created project sheet. Is there a way to do this?

Template:

Master List

Thanks,

Shahara

Andrée Starå

@Shahara Anderson

Excellent!

Happy to help!

It would be structured something like this.

=INDEX({ColumnWithTheValueYouWantToShow}, MATCH(CellThatHaveTheValueToMatch@row,{ColumnWithTheValueToMatchAgainsTheCell}, 0))

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Shahara Anderson

I hope you're well and safe!

You could use cross-sheet formulas combined with either a VLOOKUP or INDEX/MATCH structure to connect the sheets, and when you update the source sheet, it will reflect on the destination sheet.

Would that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Shahara Anderson

Hi @Andrée Starå,

I am doing well, thank you! I hope you are doing well and safe as well.

That helps; I will research that and see how to do it. I appreciate the quick response.

Have a great day!

Shahara

Andrée Starå

@Shahara Anderson

Excellent!

Happy to help!

It would be structured something like this.

=INDEX({ColumnWithTheValueYouWantToShow}, MATCH(CellThatHaveTheValueToMatch@row,{ColumnWithTheValueToMatchAgainsTheCell}, 0))

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

@Shahara Anderson

More info:

https://help.smartsheet.com/function/index

https://help.smartsheet.com/function/match

Shahara Anderson

@Andrée Starå

Thank you for the additional resources!

Best,

Shahara

Andrée Starå

@Shahara Anderson

You're more than welcome!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!