need to search a table such as distance table in road maps.

[Guest]

In a road map you normally find a distance table. I develop a spread sheet
simmilar to this and need to find the number where the column and line number
meet. Thus if I enter Town one in A1 and Town two in A2, the formula is in
A3, and will display the distance between the towns. When I change A1 or A2,
A3 will show the new distance.
Thank you.
Ronnie.

 

[Paul Lautman]

In a road map you normally find a distance table. I develop a spread
sheet simmilar to this and need to find the number where the column
and line number meet. Thus if I enter Town one in A1 and Town two in
A2, the formula is in A3, and will display the distance between the
towns. When I change A1 or A2, A3 will show the new distance.
Thank you.
Ronnie.

Do a Google search for
excel xindex

 

[Guest]

A A B C
1 1 14 11 14
14 2 4 7 1
3 9 13 12


Towns are A,B,C in row 1, columns C to E
Towns are 1,2,3 in column B, rows 2 to 4

A1=A
A2=1
A3 has formula =INDEX(C2:E4,MATCH(A1,$C$1:$E$1,0),MATCH(A2,$B$2:$B$4,0))
Result is 14

HTH

 

[RagDyeR]

See if this old post helps:

http://tinyurl.com/rdlcx

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

In a road map you normally find a distance table. I develop a spread sheet
simmilar to this and need to find the number where the column and line
number
meet. Thus if I enter Town one in A1 and Town two in A2, the formula is in
A3, and will display the distance between the towns. When I change A1 or A2,
A3 will show the new distance.
Thank you.
Ronnie.