Auto populate cells dependant on multiple inputs

Good morning all,

I have been struggling with sorting out how to auto populate 3 cells based upon the input of two. I have spent a fair amount of time to try and get this work to no avail. Any assistance would be greatly appreciated.

Essentially what I am looking to do is have the valid for, Expiry Date, and Cost auto populate by the selections made in Type of Training and Training Provided by.

I have tried using VLOOKUP and the DATE functions but have been struggling to get these accurate.

-----
The Data Sheet
- Type of Training is manually entered
- Provider is selected from the Training Providers Table (Separate table to reduce multiple copies of prover in a data validation)
- Cost is manually entered
- Valid for is manually entered.
- Training Providers is Manually Entered


Thanks again for any assistance or guidance.