Formula Needed

Micah Turner

I am tracking attendance for meetings I am doing. I need the DC # to automatically fill in when I type the name in . The data is already in another sheet, I just need the DC # that matches the name to be filled in. I am Including two screenshots. The first is where I need the formula. The second is the sheet the data is in. Thanks for any help.

Screenshot 2022-09-05 175151.jpg

Screenshot 2022-09-05 175308.jpg

Andrée Starå

Hi @Micah Turner

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.

Try something like this.

=INDEX({ColumnWithTheValueYouWantToShow}, MATCH(CellThatHaveTheValueToMatch@row,

{ColumnWithTheValueToMatchAgainsTheCell}, 0))

Did 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!

Micah Turner

Thank you. But that did not work. I might not be putting the right info because I may not be understanding what you're referencing correctly

Andrée Starå

@Micah Turner

Happy to help!

Have you added the Cross-Sheet References and replaced my formula with them? (Bolded below are what you should replace with the Cross-Sheet References and the value you're looking to match against)

=INDEX({ColumnWithTheValueYouWantToShow}, MATCH(CellThatHaveTheValueToMatch@row,

{ColumnWithTheValueToMatchAgainsTheCell}, 0))

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

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

Make sense?

✅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!