Searching a value (different tabs) using some conditionals

Hello fellas!

I'm new in this forum, so please have some patience. I'll try to be short in the explanation.

We've got a log sheet that we want to the user provide some informations and receives back a value (cost value and sell value) of the specific truck.

In my short knowledge with excel, tryed to use some functions like IF and SUMIF, but, as you can imagine, that formula would be giant and confuse - in the end it didn't work.

I'm attaching the archive and you can find some explanations to facilitate the understanding. Could someone give a help on this please?

I know that maybe we'll have to change the database or something else, and we're open to suggestions obviously.

Thanks a lot for the attention until know.