I am working on some genetic project, I have a column contain all the data with the gene name, which may come in a cluster in a cell, and i have a list which contain the gene i am interested, for example
Column B (gene list interested)
PCNA
GADD45G
bActin
p21
Column A (look up array)
PCNA;PCNA;p53
p53;p21
SOC2;SOC2
GADD45A
I want it return true if the string in column A contain any of the gene name in column B.
I can only come out a formula =isnumber(match(A2,B:B,0))>1 which returns only an exact match. what formula can i use to return if it contains any of the gene listed in column B?
Bookmarks