Search and find the difference

Hi,

I have attached the excel files which contains the type of format I use.

I need to calculate the received when..

search by client name using "*"&Cell reference&"*" then match the expiration date then transaction type. if all conditions are true, then calculate the difference between i.e. Subtract expiration date - recieived date..

if more information is required i will provide..

Please advise..