Is it just the word "text" that would be contained in G2 or is "text" a substring of what's in G2?
if so, try
=if(Isnumber(search("Text",G2)),H2,"")
Is it just the word "text" that would be contained in G2 or is "text" a substring of what's in G2?
if so, try
=if(Isnumber(search("Text",G2)),H2,"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks