J
JRichardson
I am trying to write a formula that will return a price from an array based
on a product & location. The array that I am want to do the lookup off of
looks like this:
Product 1 Product 2 Product 3
Location 1 $1.00 $2.00 $3.00
Location 2 $1.25 $2.25 $3.25
Location 3 $1.50 $2.50 $3.50
My spreadsheets has a "pulldown" (validation) for the location & then I have
a list of the products. I need a lookup/index that will pull the right cost
if the location & product intersect.
I have tried match & index and I think I must be doing something wrong as I
keep getting #N/A's.
Hope this makes sense. Thanks! j
on a product & location. The array that I am want to do the lookup off of
looks like this:
Product 1 Product 2 Product 3
Location 1 $1.00 $2.00 $3.00
Location 2 $1.25 $2.25 $3.25
Location 3 $1.50 $2.50 $3.50
My spreadsheets has a "pulldown" (validation) for the location & then I have
a list of the products. I need a lookup/index that will pull the right cost
if the location & product intersect.
I have tried match & index and I think I must be doing something wrong as I
keep getting #N/A's.
Hope this makes sense. Thanks! j