View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default need to search a table such as distance table in road maps.

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.