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!

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)

"LJoe" wrote in message
...
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!

Great! Thank You!

"Bob Phillips" wrote:

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)

"LJoe" wrote in message
...
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!