See if this old post helps:
http://tinyurl.com/rdlcx
--
HTH,
RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===
"Ronnie" wrote in message
...
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.