| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
index/match/lookup???
Worked Great!!!! Thank you!!!
-- www.bardpv.com Tempe, Arizona "Dave Peterson" wrote: Debra Dalgleish shows how to use =index(match()) for this: http://www.contextures.com/xlFunctions03.html (Look at example 2) Emma Aumack wrote: 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 -- Dave Peterson |
Threaded Mode
