lookup in a grid/table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

greetings,
I would like to lookup a value in a table. It is a table of distances
between cities. What I don't no how to do is to create the funtion so that
the inputs are user input.
e.g.
cell a1: (from city, user input)
cell b1: (destination city inut)

using these two inputs I'd like to refer to a table of distances between
cities.
e.g.
city a city b city c
city A 0 50 75
city b 50 0 150
city c 75 150 0

any suggestions?
 
You need a database for this and some serverside programming.

Regards Jens Peter Karlsen. Microsoft MVP - Frontpage.
 
Back
Top