vLOOKUP on Multiple Dropdowns Pulling, Calculating Totals
Hoping someone can help! I am have created a multiple dropdown list in one column (a), and a VLOOKUP function using this data in a separate column (b) to pull through pricing from another sheet.
I am having some issues when column A has more than one option selected. How can I create a formula that checks all options included in column A, looks up the corresponding pricing in the separate sheet, and totals up the prices selected to show in column B?
Thanks in advance!
Tags:
Answers
-
You will need to use a SUMIFS instead. Something along the line of...
=SUMIFS({Price Sheet Price Column}, {Price Sheet Item Column}, HAS([Multi-Select Dropdown]@row, @cell))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!