Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Sep 12, 2019 09:24 AM
Hello everyone! I’m trying to make a base for a big fundraiser that has multiple tables. Is it possible to have a column in one table return a designated value from another table relative to the value in an adjacent cell (very similar to vlookup in excel).
As an example, I have one table that will be for all the guest info (name, ticket type, ticket cost) and I want to be able to set the ticket type in one column, and have it atomically fill the number of tickets associated with that level along with the cost of that sponsorship in a third column. For example, at this event, a Partner Level Sponsor gets four tickets at the cost of $500.
Is there a way to do this without complicated formulas - which I’ve used for the past two years in an excel sheet, but want to transition over to AirTable for the powerful cross referencing.
Thanks!
Sep 12, 2019 11:35 AM
Hi @Andrew_Doll - if you set up the quantity and cost against the ticket type, you can then look these up in the guests table:
Ticket Type is a linked field to the Ticket Types table and Quantity and Cost are lookup fields.
Is this what you are after?
JB
Sep 13, 2019 08:05 AM
Thats perfect! Thanks so much @JonathanBowen!