index/ match formulas orice

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

Bob Phillips

=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)
 
L

LJoe

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

Bob Phillips

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Index/ Match Formula 2
Index Match with Min 2
Calculate end date and time 1
Vlookup and return sheet name also 2
Match and Vlookup issue 2
INDEX and MATCH with range 3
Match issue 3
What type of "lookup" 3

Top