Here is my dilema . . .


On Wksht1 I have the following data

Prod Code PriceLevel Price

Prod1 1
Prod2 3
Prod3 2
Prod4 3
Prod5 1

In Wksht2 is

ProdCode 1 2 3
Prod1 1.00 .75 .50
Prod2 10.00 8.00 6.00
Prod3 34.00 26.00 18.00
Prod4 18.00 17.00 16.00
Prod5 5.00 4.00 3.00

In worksheet 1 I need to fill in the price for each product by looking up
the product code in worksheet 2 then going to the appropriate column (price
level) and getting the price where product code and price level intersect.

I know there is a formula for this but I can't for the life of me find it?
Can someone please help???

Thank you,


--
www.bardpv.com
Tempe, Arizona