Hi I am new to Airtables and trying to create a formula that uses data from another table, is this possible?
Yes I think using Lookup you can achieve
Yes. You will need to create a Link field in one the two tables to tie the data together.
Then you can pull information depending on what you need it for using Rollups, Lookups, Counts, etc.