Hi,
I creating a list of names and each name (row) has at least 3 keywords as in the table below.
#
Name XXX Kewords A AA C, D, E B BB C, F, G
now I would like to write a function that allows each user to search a maximum of 2 keywords and see which names have those keywords.
example:
let's say the user wants to search keyword C, the answer would be: names A and B. Then the user searches keyword E and the answer would be: name A.
I would appreciate it if anyone would help me with this.
Bookmarks