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!
|