Index/ Match Formula

L

LJoe

In my index/ match formula, what does the A3= reference. My sheets are set
up this way:
Sheet 1
A B C D E F
Market Prod Type List $ Dist$ Markup New List$

Sheet 2
A B C D
Market Prod Type List% Dist%
100% 80%
INDEX('Price Reference'!D3:D200,MATCH(1,(A3='Price
Reference'!A3:A200)*('Price Reference'!B3:B200)))

I want whatever can be substituted for A3 to match the Market/ Prod Type in
a range A1:A200. I am hoping the A3 is doing that, but I think it is just
referencing the one cell.

Thank you Dave Peterson for helping me with the formula and thank you in
advance for your answers!
 
B

Bob Phillips

It is matching A3 against the array of values in Price Reference A3:A200,
and if the equivalent cell in B is not 0, it returns the value in C.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
L

LJoe

Great! Thank You!

Bob Phillips said:
It is matching A3 against the array of values in Price Reference A3:A200,
and if the equivalent cell in B is not 0, it returns the value in C.

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

Top