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
Service Plan	Cost
Service 1
Service 2
Service 3
Service 4
Service 5
Service 6
Level
Service 3

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]

[TD="align: right"]76.78[/TD]

[TD="align: center"]3[/TD]

[TD="align: right"]27.61[/TD]

[TD="align: center"]4[/TD]

[TD="align: right"]64.64[/TD]

[TD="align: center"]5[/TD]

[TD="align: right"]59.81[/TD]

[TD="align: center"]6[/TD]

[TD="align: right"]41.74[/TD]

[TD="align: center"]7[/TD]

[TD="align: right"]10.17[/TD]

[TD="align: center"]8[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]9[/TD]

[TD="align: right"][/TD]

[TD="align: center"]10[/TD]

[TD="align: right"]169.03[/TD]

</tbody>

Sheet2​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B10[/TH]
[TD="align: left"]=SUM(B2:INDEX(B2:B7,MATCH(A10,A2:A7,0)))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

Thank you