D
Doug
I have a worksheet that contains price information for several customers ...
across the top row are customer names ( b1, c1 .... m1) and down the first
column are the item numbers (a2, a3 ... a195) ...
I am entering the sales data in another worksheet with customer name, item
number and quantity .... I want to create a lookup formula or any other
formula that will work to lookup the customer specific sales price for that
item .... the goal will be to have a sales extension formula and use this
data in a pivot table ...
Can any one help?
across the top row are customer names ( b1, c1 .... m1) and down the first
column are the item numbers (a2, a3 ... a195) ...
I am entering the sales data in another worksheet with customer name, item
number and quantity .... I want to create a lookup formula or any other
formula that will work to lookup the customer specific sales price for that
item .... the goal will be to have a sales extension formula and use this
data in a pivot table ...
Can any one help?