Hi All,

I have a large mileage spreadsheet that I use at work (a small exampl
of which appears below with letters A through D substituting for th
real names). My problem is that I want to either have a userform o
use a formula to be able to return the distance between two places

eg Place A - Place C = 8 miles, or Place C to Place D = 7 miles.

Ideally I'd like to have 2 controls that the user completes with th
name of start point and end point and the code (or function) shoul
return the distance between the two.

I think the formula should be something like LOOKUP but I don't eve
know where to start.

I'd be really grateful if someone could point me in the righ
direction



A B C D
A * 5 8 9
B 5 * 3 4
C 8 3 * 7
D 9 4 7 *

Thanks in advance

Seamu

--
Message posted from http://www.ExcelForum.com