What formula would I use to read a date from another sheet?

haley brianne

I have a sheet that collects dates in a column "CO Internal Target", I want to be able to list that date on another sheet with a formula. It should be able to read the "Studio Code". Both of the columns are on both sheets. The sheet that I am wanting to read from is the "Location Tracker - SS", the sheet that it is going to is the "Equipment Ordering"

I have been trying the below formula, but it doesn't work. Please let me know if you need more information to solve!

=IFERROR(INDEX({Location Tracker - SS Range 1}, MATCH([Studio Code]@row, {Location Tracker - SS Range 2})), "")

Andrée Starå

Hi @haley brianne

I hope you're well and safe!

Have you created the cross-sheet references?

Try something like this.

=IFERROR(INDEX({Location Tracker - SS Range 1}, MATCH([Studio Code]@row, {Location Tracker - SS Range 2},0)), "")

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!

haley brianne

Andrée Starå

Hi @haley brianne

I hope you're well and safe!

Have you created the cross-sheet references?

Try something like this.

=IFERROR(INDEX({Location Tracker - SS Range 1}, MATCH([Studio Code]@row, {Location Tracker - SS Range 2},0)), "")

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!

haley brianne

I just figured it out at the same time!! Thanks.

Andrée Starå

@haley brianne

Excellent!

Happy to help!