Help! I'm trying to create formula that will search for a text string to start a range for a sumif formula.

For example I'm looking for the word "go." This formula will find "go" and use it as the starting point in the range for a sumif or vlookup formula.

I hope that's clear enough. Thanks!