Excel version of IF - WHERE

[madamimadam]

Still having "fun" learning the complexities of Excel. The current task I'm stuck with is introducing a form of "where" statement into a formula.

I have a 3 column data set (customer, code, quantity) which I import from our accounting system.

I want excel to automatically fill out the back order position on various customer tabs based on this raw data.

The way I picture it in my head is that I want it to do a VLOOKUP on the product codes and quantity where the first column is equal to the name of the customer.

Has anyone done anything like this?

Attached is an example doc

The tabs "Customer One", "Customer Two", "Customer Three", and "Customer Four" have a template showing product codes and descriptions. The tab "Back Orders" shows how much of each product code the individual customers have on back order.

I need the data from "Back Orders" to populate the various customer tabs.

Example_Worksheet.zip