How to make a selection of unique values ​​from a range that satisfies the condition and then replace these values?

Question

Google Sheets

Let's say there are two tables, one of them contains data, and the second summarizes the result.
More details can be found in the document Selection with replacement

Answer 1

You need to make a reference book in which you need to describe all the possible values ​​​​of the contents of the box and compare the results for them.
After that, using the VLOOKUP function, run through the contents in the table and pull up the values ​​from the directory, here is the solution:
https://docs.google.com/spreadsheets/d/1qDDU7GFuKa...
Here is the D2 formula: ="Driver "&B2&" is carrying box number" &A2&" where "&VLOOKUP($C2;'lookup'!$A$1:$B$7;2;0)

Answer 2

I almost solved the problem, it remains to remove extra characters from the string and form a phrase.