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!

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul Newcome

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))

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.