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,"")