Lookup formula

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

Frank Kabel

Hi
use something like
=INDEX('data_sheet'!A1:M20,MATCH("customer",A1:M1,0),MATCH("item",A1:A2
0,0))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top