Returning value from multiple texts in one cell

[rkml4]

Good day
I am looking for some help please
I have a list of products names in one cell that have more than one word and the second cell is a number

example

member full 10
member full with add-ons 10
new member full 10
member junior 5

I'm looking on how to read the first cell and recognise the words member and full only and then return in this case 30
I've tried various ideas but just going around in circles
any help is really appreciated
thank you

 

[Peter_SSs]

Welcome to the MrExcel board!

I suggest that you investigate XL2BB for providing sample data & expected results to make it easier for helpers to understand just what you have & where it is and also what you want & where it is to be.

Could this work for you?

24 03 10.xlsm
	A	B	C	D
1
2	Member full	10		30
3	Member full with add-ons	10
4	new member full	10
5	member junior	5
rkml4

Cell Formulas
Range	Formula
D2	D2	=SUMIFS(B2:B5,A2:A5,"*member full*")

 

[rkml4]

God . So simple . Thank you
Appreciate the advice on explaining my question with sample data . Yes looking now at my post it can be seen as a bit ambiguous. Thanks again

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.