Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
index/ match formulas orice
I am trying to figure out the formula I need to use to bring back the price
grouping. Sheet 1 A3 A1 A2 List Dist. Mark Up New List New Dist Market Product Type 80 50 5% Sheet 2 A1 A2 List Dist Market Product Type 100% 60% I need to be able to match the market and product type in sheet 1 to sheet 2 to get the % between the price groupings to be brought back to sheet 1 to determine pricing. I have been trying different index/ match formulas and it keeps telling me there is an error. I believe to get it to calculate price in sheet one I use(+($a3*(1+$a3). I have read other posts on the message board and am confident you'll be able to help me. Thanks a bunch! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Returning MULTIPLE values with Index and Match | Excel Discussion (Misc queries) | |||
Using AutoFilter to Sort Data Pulled in by INDEX / MATCH | Excel Worksheet Functions | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Help Please - Match & Index Functions (I hope)! | Excel Discussion (Misc queries) | |||
Index and Match | Excel Worksheet Functions |