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