Count Multiple Values in Sheet2 based on Unique Reference in Sheet1

Due to the number of views, but zero opening of the attachment - I would just like to add that the data is just a convenient example and not actually for an insurance company!

Have I worded my post badly? I don't think these are particuarly difficult formulas...

Thanks canapone,

However the fact that there are multiple Vehicles and Incident Types make this a little more involved than the formulas recommended. The formulas must work off the data in the Vehicles! sheet.

=COUNTIF(Vehicles!$B$2:$B$24,A2)
This does not take into consideration the the same vehicle can appear twice, therefore appearing as "2" when there was only one car.

=IF(C2="Recovered","yes","")
There can be multiple vehicles and incident types, so this only accounts for vehicles picked up in INDEX MATCH formula - not necessarily picking up the recovered vehicle.

=IF(AND(B2="Home Address",C2="Stolen"),"Yes","")
Same as limitation above.

This:
=IF(SUMPRODUCT((Vehicles!$A$2:$A$24 = "Recovered")*(Vehicles!$B$2:$B$24=A2)),"Yes","")
Works instead of this:
=IF(C2="Recovered","yes","")


And this:
=IF(SUMPRODUCT((Vehicles!$A$2:$A$24 = "Stolen")*(B2="Home Address")*(Vehicles!$B$2:$B$24=A2)),"Yes","")
Works instead of this:
=IF(AND(B2="Home Address",C2="Stolen"),"Yes","")

Phew, all afternoon but got there.