Formula to return text based on two criteria

Hi

I need a formula to bring back a cost based on a date and category. The categories have two costs between a different range of dates. I have attached an example to help explain.

I tried =lookup formula but it didn't work, it seemed to stop at the first cost amount from the category it found.

I would appreciate any help.

Thanks