Display a value at intersecting point Closed

Question

Hello,
I am trying to do the following.

Location         A   B   C    D    E
                  A  1   2    3    4    5
                  B  2   1    2    3    4
                  C  3   2    1    2    3
                  D  4   3    2    1    2
                  E  5   4    3    2    1

Now if I am sending a parcel from A to A there will be a tariff (fairly cheap)  But as the distance gets greater then the tariff increase.  The tariff schedule is HUGE so I need to write a formula to try and locate the intersecting point on the tariff table based on two values selected from a dropdown list (which is based on my table)

I don't actually know if I'm explaining this correctly.  My excell skills are not that strong.

Appreciate ANY help.

Ta kindly,

Pooklet

Pooklet · Answer

I found the Intersection function sort of helpful but it still doesn't solve my problem.  The table with headings is still very big.  I have my users selecting the locations from a dropdown list.  Unfortunately the intersection function would mean that they would have to type the formula (=MyHeading1(space) MyHeading2) in every single time.   I've tried to concatenate then use it in the Intersection function but that doesn't work as it is looking up the cell reference.

Display a value at intersecting point

1 response

Similar discussions

Subscribe To Our Newsletter!