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

Rebecca Larkin-Martinez

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)

Rebecca Larkin-Martinez

The Approver name is being looked up in the first column of the reference Data "Community Metrics" and that column can have 1 or more names.

James Keuning

is there a limit to the number of names that will appear in a cell? Are they delimited? If there is a maximum number of names, and you have a delimiter, you could use a bunch of FIND formulas to parse the field into columns, and then search the columns using MATCH and INDEX.

Rebecca Larkin-Martinez

@James Keuning ah thank you!

James Keuning

You know what, I might be leading you in the wrong direction. Have you tried HAS instead of FIND?

https://help.smartsheet.com/function/has

Rebecca Larkin-Martinez

I has not but will! LOL Thank you!