Return an amount with a criteria

[Marwan69]

Hello everyone and please pay a smile when you work this because it's a pain...

I have a table and I'd like to return an amount based on criteria. Let me explain below:

Financial Figures (SR'000)	Salama	Yearly Change(%)
Cash & Cash Equivalents
2013
Insurance Operations(Takaful Operations)
Cash on hand and at banks	36,465	-35.35%
Term deposits - (<= 3 mos)	0
Term deposits - (>3<12 mos)	10,576	190.65%
Shareholders' Operations
Cash on hand and at banks	33	16639.39%
Term deposits - (<= 3 mos)	0
Term deposits - (>3<12 mos)	0
2014
Insurance Operations(Takaful Operations)
Cash on hand and at banks	23,573	-88.58%
Term deposits - (<= 3 mos)	0
Term deposits - (>3<12 mos)	30,739	-64.34%
Shareholders' Operations:
Cash on hand and at banks	5,524	-99.86%
Term deposits - (<= 3 mos)	0

<tbody>
</tbody>

I'd like the formula to return -35.35% under (Yearly change%) column but based on the following criteria:
I want the formula to read this criteriaInsurance Operations(Takaful Operations)) and this criteria: (Cash on hand and at banks) and therefore return to me the (Yearly change%). Hope is clear.

Why is that? Because I have two operations: (Insurance operations(Takaful Operations) and (Shareholders' Operations). I want first to return the yearly change% pertaining to insurance operations and then jump to shareholders' operations.

I wish this didn't cause pain to you guys!!!Many thanks,
Marwan

 

[Marwan69]

Many thanks RasGhul. It worked!

 

[RasGhul]

You're Welcome