I have a grid with sales growth % listed across the grid on top and profit
growth listed vertically down the left side. I need to find the
intersection point between a particular sales growth number and profit growth
number (numbers are listed). Is there a formula (or other way ) that could
do this?

I.e. if sales growth is 3% and profit growth is 2%, I need the number 15
to appear in a cell


sales growth
1% 2% 3% 4% 5%
1% 5 10 15 20 30

2% 5 10 15 20 30

3% 5 10 15 20 30

4% 5 10 15 20 30

Say you data is in the range B3:F6 with row 2 used for Sales growth % from
b2:f2 and proft growth in cell A3:a6

this formula will get you 15

=INDEX($B$3:$F$6,MATCH(A4,$A$3:$A$6,0),MATCH(D2,$B $2:$F$2,0))
where above A4 = 2% and D2=3%



"MRR" wrote:

I have a grid with sales growth % listed across the grid on top and profit
growth listed vertically down the left side. I need to find the
intersection point between a particular sales growth number and profit growth
number (numbers are listed). Is there a formula (or other way ) that could
do this?

I.e. if sales growth is 3% and profit growth is 2%, I need the number 15
to appear in a cell


sales growth
1% 2% 3% 4% 5%
1% 5 10 15 20 30

2% 5 10 15 20 30

3% 5 10 15 20 30

4% 5 10 15 20 30

What if the data doesn't "Match" but rather is in a range. Is there another
word to use?

"N Harkawat" wrote:

Say you data is in the range B3:F6 with row 2 used for Sales growth % from
b2:f2 and proft growth in cell A3:a6

this formula will get you 15

=INDEX($B$3:$F$6,MATCH(A4,$A$3:$A$6,0),MATCH(D2,$B $2:$F$2,0))
where above A4 = 2% and D2=3%



"MRR" wrote:

I have a grid with sales growth % listed across the grid on top and profit
growth listed vertically down the left side. I need to find the
intersection point between a particular sales growth number and profit growth
number (numbers are listed). Is there a formula (or other way ) that could
do this?

I.e. if sales growth is 3% and profit growth is 2%, I need the number 15
to appear in a cell


sales growth
1% 2% 3% 4% 5%
1% 5 10 15 20 30

2% 5 10 15 20 30

3% 5 10 15 20 30

4% 5 10 15 20 30

Disregard that last replay, I figured it out. You use "1" instead of "0" in
the Match formula.

Thanks for your help N Harkawat!!!

"MRR" wrote:

What if the data doesn't "Match" but rather is in a range. Is there another
word to use?

"N Harkawat" wrote:

Say you data is in the range B3:F6 with row 2 used for Sales growth % from
b2:f2 and proft growth in cell A3:a6

this formula will get you 15

=INDEX($B$3:$F$6,MATCH(A4,$A$3:$A$6,0),MATCH(D2,$B $2:$F$2,0))
where above A4 = 2% and D2=3%



"MRR" wrote:

I have a grid with sales growth % listed across the grid on top and profit
growth listed vertically down the left side. I need to find the
intersection point between a particular sales growth number and profit growth
number (numbers are listed). Is there a formula (or other way ) that could
do this?

I.e. if sales growth is 3% and profit growth is 2%, I need the number 15
to appear in a cell


sales growth
1% 2% 3% 4% 5%
1% 5 10 15 20 30

2% 5 10 15 20 30

3% 5 10 15 20 30

4% 5 10 15 20 30