lookup in a grid/table

[dave in Toronto]

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?

 

[Jens Peter Karlsen [FP-MVP]]

You need a database for this and some serverside programming.

Regards Jens Peter Karlsen. Microsoft MVP - Frontpage.