Lookup formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Hi
use something like
=INDEX('data_sheet'!A1:M20,MATCH("customer",A1:M1,0),MATCH("item",A1:A2
0,0))
 
Back
Top