V-lookup in Pivot Table

Dear Gurus,
I have attached a partial workbook for this problem. How would I do a vlookup by customer code so that it puts weights in column D of "Customers" tab, considering individual routes. It means that a customer code may show up in several routes.
Thank you!