Formula that takes data from corresponding data set if a condition is met

All,

I have two raw data sets that need to be consolidated automatically if a criteria is met.

For example, if the fleet number of one data set is = to the fleet number of another data set I need it to take the start date from one of the data sets. If not, it needs to continue searching for the row where the fleet number correlates. This is similar for three columns.

I understand I may not of explained this very well and so have set up a dummy worksheet where the cells that need filling are highlighted yellow (columns AH onwards), with a brief description of how beneath. I will need this to be a formula so that it automatically updates every time new raw data is inserted and unfortunately I do not have time to learn how to use macros.

Many thanks in advance!

Raw data 1 - though this and the cells used shall change as the dummy sheet is different from actual sheet (due to confidentiality reasons). I plan to alter your formula slightly to accommodate these changes, as I did yesterday. Will there be any problems with that?

Many thanks

So the start date should source data from Raw Data 1 if the correlating Fleet No is the same as that of those in columns AB.
For calendar days on hire it should be the correlating data from raw data 2 plus the cell in column J where the Fleet Number matches.
Chargeable days on hire is practically the same as calendar days.

Many thanks