Can you do a VLookup to a column that has multiple entries


I am executing a Vlookup to look for a single name in a cell that may have multiple names. I am getting a No Match error, even if I am specifying - not an exact match I have tried both True and False and with multiple values in a cell I cannot ensure an ascending order.

=VLOOKUP(Approver@row, {Community Metrics}, 2, true)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!