Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Good day, I am hoping someone can help me with this formula
I have a result sheet and on the result sheet I have a section that shows the part number (c33) and a price level (O5), along with quantity (G18) These part numbers and price levels are on another sheet (prices) with pricing. On the prices sheet the part numbers are in column B22 - B41 and price levels from in Row C21 - N21. inbetween are the actual prices per part number per price level (like a multiplication table where if you run your finger from level G down and accross from part X you will find the corresponding price) what I am looking for in the tally sheet is from another cell (P42) calculate the formula stating that if part number = X and price level = I take the intersecting price (from the price sheet) and multiply it by the quantity on the tally sheet and place the total in Q33. Can anyone help me with this? Thanks in advance -- Neall |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Goto last row of the sheet | Excel Worksheet Functions | |||
Goto Tab | Excel Discussion (Misc queries) | |||
Gosub - Goto ? | Excel Worksheet Functions | |||
goto (F5) question | Excel Discussion (Misc queries) | |||
If.....Then GoTo....... | Excel Discussion (Misc queries) |