VLOOKUP on a Multi DropDown List

I'm attempting to setup an asset tracking system using Smartsheets, where individuals fill out a form requesting specific assets, in which they'd be assigned in the sheet using a multi select dropdown of all the asset barcodes.

In another sheet I have all the assets accounted for, each in their own row. I'm trying to use VLOOKUP in this sheet to look across the assigned column in Sheet 1 to then fill relevant information about each asset (who it's been loaned to, etc). This works when there is only one value in the cell, however should anyone pick more than one dropdown value VLOOKUP returns a NO MATCH.

Any ideas on how to accomplish?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!