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?
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?