need to search a table such as distance table in road maps.
Ronnie wrote:
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
|