Returning one Value contained in a List

Hi, I have a list of data in column G containing multiple values seperated by commas.
I want to reference a list in column B and then if a value in that list is located in the cell in Column G, I want it to return that value.
For example, my list is made up of the following values, red, red ball, red pen, make, shift, computer.
I then want it to look at my cell in column G and return only 1 value based on the most appropriate match.
If the cell in column G, contains the values red ball, walk, show, tent, invade. I just want it to return 'red ball', rather than both 'red' and red ball.

I have tried multiple formulas but no luck yet.
=TEXTJOIN(", ",TRUE,IF(COUNTIF(G2,"*"&$B$2:$B$10&"*"),$B$2:$B$10,"")) - This will return all values seperated by a comma

=IF(OR(INDEX(COUNTIF(G2,"*"&($B$2:$B$10)&"*"),)),$B$2:$B$10,"") - This doesnt seem to work because it doesnt know which value to return.

Any help would be much appreciated.

Originally Posted by GeoffW283

Strogg: Assuming that we're on the right track at all, there may be a minor issue with your formula in that if there is a prefix to any of the words in G2 then your formula still sees a match. For example, changing "make" in G2 to "matchmake" will still be seen as a match to "make" in col-B.

Thank you. Yesterday, first I was trying to do it in an almost similar way, but missed an option with the MATCH function.

Hi Geoff/ Strogg,

Thank you both, that is both a massive help.
I am just wondering is there a way of altering the formula so that it only returns one answer per line so that it then can be dragged down and made applicable to each line.
For example, I have put my ideal output in Column I, which corresponds to the list in Column B.
SO it wouldnt return any value in I2 because 'red' is not an exact match, it would have to be 'red ball'. I am not sure if this is possible.

Thanks again to both of you for your help.

Hi Ali,
there could be a few different variations in the list and I am wondering can it return the most applicable result based on that current line. SO your example seems to return 'computer' for each line. Whereas I would only want it to return computer on the line where computer is within the list. I also need it to return 'red ball' on the line where that is present and then blanks for everything else

Thanks

And one more option, almost the same as above.

PHP Code: 

=IF(AGGREGATE(14;6;N(TRIM(MID(SUBSTITUTE($G$2;",";REPT(" ";99));(ROW($A$1:$A$20)-1)*98+1;99))=B2);1);B2;"")