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!

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!

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!

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!