Help

Vlookup between 2 tables and return sum total

Topic Labels: Formulas
Solved
Jump to Solution
771 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.