What formula can I use, Help please!!!

  • Thread starter Thread starter Olivia
  • Start date Start date
O

Olivia

I need to find a formula that looks up a x & y factor and
then give me the # that is the intercept. I do not think
that the intercept formula is the one that I need. Here
is an example of what I need to do.

y 1 2 3 4 5
x
1 0 5 1 6 2
2 1 6 2 7 3
3 2 7 3 8 4
4 3 8 4 9 5
5 4 9 5 1 6

I want the value that is X3&Y4 the value =8. How can I do
this? Please help me I am desperate!!! Thanks - OMR
 
I need to find a formula that looks up a x & y factor and
then give me the # that is the intercept. I do not think
that the intercept formula is the one that I need. Here
is an example of what I need to do.

y 1 2 3 4 5
x
1 0 5 1 6 2
2 1 6 2 7 3
3 2 7 3 8 4
4 3 8 4 9 5
5 4 9 5 1 6

I want the value that is X3&Y4 the value =8. How can I do
this? Please help me I am desperate!!! Thanks - OMR
Click to expand...

One method using the intersection operator.

Set up an array like this:

Y1 Y2 Y3 Y4 Y5
X1 0 5 1 6 2
X2 1 6 2 7 3
X3 2 7 3 8 4
X4 3 8 4 9 5
X5 4 9 5 1 6

Select the entire array.

Then Insert/Name/Create
Leave Top Row and Left Column selected.

To obtain your desired result, insert the following into a cell:

=X3_ Y4_

The underscore is necessary in these names as otherwise X3 and Y4 would be
interpreted as cell references rather than names.


--ron
 
Back
Top