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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
index/ match formulas orice
=INDEX(Sheet2!C1:C100,MATCH(1,(Sheet2!A1:A100=A1)* (Sheet2!B1:B100=B1),0))
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "LJoe" wrote in message ... 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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
index/ match formulas orice
It keeps telling me I have too few arguments. I'm sure I have everything
right on it, could something else be wrong? Thank you Bob! "Bob Phillips" wrote: =INDEX(Sheet2!C1:C100,MATCH(1,(Sheet2!A1:A100=A1)* (Sheet2!B1:B100=B1),0)) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "LJoe" wrote in message ... 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! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
index/ match formulas orice
I did forget to mention that it isan array formula, it should be committed
with Ctrl-Shift-Enter, not just Enter. Other than that it works as I understand the question. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "LJoe" wrote in message ... It keeps telling me I have too few arguments. I'm sure I have everything right on it, could something else be wrong? Thank you Bob! "Bob Phillips" wrote: =INDEX(Sheet2!C1:C100,MATCH(1,(Sheet2!A1:A100=A1)* (Sheet2!B1:B100=B1),0)) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "LJoe" wrote in message ... 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! |
Reply |
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 |