I have a question about an array.
I have one column with a list of words i.e.
[4 star hotels aruba]
[4 star hotels in aruba]
[5 star aruba hotels]
[5 star aruba resorts]
[5 star hotel aruba]
[5 star hotel in aruba]
Column B contains a list of destinations, I would like to know if there is a functions to look at each entry in column A and spit out the specific destination that is present in column A.
My current forumla is below but it only spits out a "TRUE" if the destination is present. I would like for it to spit out the actual destination. Can anyone help?