Is it possible to use Multiple criteria from a single cell for lookup or index match?

[marlina]

Let's say we have a table
service 1 price
service 2 price
service 3 price

cell A1 contains service 1, service 2

And we get values of service 1 and service 2 from the table. If we add service 3 in the cell A1, we get all the values.

 

[mrhstn]

I think something along these lines...

Book1
	A	B
1	Service Plan	Cost
2	Service 1	76.78
3	Service 2	27.61
4	Service 3	64.64
5	Service 4	59.81
6	Service 5	41.74
7	Service 6	10.17
8
9	Level
10	Service 3	169.03
Sheet2

Cell Formulas
Range	Formula
B10	=SUM(B2:INDEX(B2:B7,MATCH(A10,A2:A7,0)))

 

[marlina]

I think something along these lines...

	A	B
1	Service Plan	Cost
2	Service 1	76.78
3	Service 2	27.61
4	Service 3	64.64
5	Service 4	59.81
6	Service 5	41.74
7	Service 6	10.17
8
9	Level
10	Service 3	169.03

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet2​

Worksheet Formulas Cell Formula B10 =SUM(B2:INDEX(B2:B7,MATCH(A10,A2:A7,0))) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

Thank you