VLOOKUP with Multi-Select Pick List Column
Hey there! I have an order form that allows users to select multiple products from a multi-select dropdown list. These values are contained in that column once the form is submitted.
On another sheet, I have the prices for each product listed.
I'd like to do a VLOOKUP for each item ordered, within the sheet with all the prices, to return a price for each product, but clearly I can't specify multiple values to search. I think I once solved this, but can't find my reference sheet.
I only have maybe 15 products, so I can easily set up 15 different lookups, each with their own destination cell, then sum these in a "Total Order Value" column.
Help Article Resources
Check out the Formula Handbook template!