Lookup with contains()

[Gaetan_Fizero]

Hi!

Do you know how i can do something similar to this ?

MrExcel Message Board

Vlookup or similar function & "Contains"

I am looking for a vlookup or similar function where the lookup value may be in a different form. Meaning. In my lookup value, it could be: John Smith. But in the first column in my aray, it could be J. Smith/Smith, John/or John Smith. So I...

I have a column with multiple emails separated with a comma (test@gmail.com, test2@gmail.com), and i would like to use a lookup function to check if my value is contained in this column and return a associated column.

Thanks for your help!

[Suvrutt_Gurjar]

If I have understood your requirement correctly, you could use a SELECT() instead of LOOKUP()

Reason: Please refer article on LOOKUP() LOOKUP() is anyway a wrapper on SELECT() . 3 of LOOKUP() arguments may not have complex expressions. So you may not have CONTAINS() etc. within LOOKUP()

help.appsheet.com

LOOKUP()

Get column value from row in table or slice

Finally your statement below means you have a column type list or enumlist that contains a list of emails.

Gaetan_Fizero:

I have a column with multiple emails separated with a comma (test@gmail.com, test2@gmail.com)

if all above is true, then you could have a SELECT() statement something like below

ANY(SELECT(Table Name[ Return Column], IN( USEREMAIL() , [Email list Enumlist or list type column])))

Please replace USEREMAIL() with value to find if you have some other email to search rather than USEREMAIL(). Remove ANY() if your return value is likely to be spread acrosss many rows.

[Gaetan_Fizero]

It’s perfect !

Thank you !!