+10I 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?
Best answer by Nedra_Hines
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.
If they are linked, then the Rollup field can be used.
+10If they are linked, then the Rollup field can be used.
I looked at both Rollup and Lookup and didn't see how to make it work.
+10OMG 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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
