Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Vlookup between 2 tables and return sum total

Topic Labels: Formulas
Solved
Jump to Solution
1915 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Nedra_Hines
6 - Interface Innovator
6 - Interface Innovator

I have 2 tables: “Home Staging Projects” and “Inventory Items”. In the “Home Staging Projects” table, I want to vlookup on the “Project ID” and return the sum total of “Rental Price” for each inventory item selected for that project listed on the “Inventory Items” table. I hope that makes sense.

I’m not sure if this makes a difference, but the “Inventory Items” table is linked to the “Home Staging Projects” table by (formula) “Project ID”.

Is there a way to use a formula for this?

1 Solution

Accepted Solutions
Nedra_Hines
6 - Interface Innovator
6 - Interface Innovator

OMG IT WORKED!!!! THANK YOU SO MUCH! I wouldn't have ever thought of that, and I've watched several Youtube videos to figure this out. I really appreciate it so much.

See Solution in Thread

4 Replies 4
Sho
11 - Venus
11 - Venus

If they are linked, then the Rollup field can be used.

Rollup Field - Overview | Airtable Support

I looked at both Rollup and Lookup and didn't see how to make it work.

Sho
11 - Venus
11 - Venus

Add a Rollup field to "Home Staging Projects" table
2023-08-21 104900.png

 Can you set it up like this?

Nedra_Hines
6 - Interface Innovator
6 - Interface Innovator

OMG IT WORKED!!!! THANK YOU SO MUCH! I wouldn't have ever thought of that, and I've watched several Youtube videos to figure this out. I really appreciate it so much.