Excel formula for search from sentence

Our customers use all kind of payment reference when they make payment. Sometime they use company number, name and invoice number. The team need to check different approach to find a customer number. so I need the formula to check if it's invoice number then check specific location and if company number then look a different range and put the information. Once I have Invoice number separated from payment reference then I can VLOOKUP for customer

I need to find a word from the sentence in cell C2 from the range from column G. Once a specific word is found from range column G, update the result in cell D2.

Attached is a sample file.

appreciate for your help in advance.