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