Help with reference tables

Guys I have a very simple form app that captures data from a rugby game. I use 2 tabs. One to capture the date, play level and the two teams involved. The other tab captures the physical game events. I just want each new ‘play’ in the second tab to drag in data from the first, so that each data entry contains the id, date, teams etc as well as the data from the play itself.

This is my Google sheet:

I would appreciate any help.

Regards,

Brendon

@Rugbycology_Analytic
Check this page:

2 Likes

Thanks for that Leventh,

I am about to start studying this!

Regards,

Brendon

1 Like

You’re welcome