View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
davesexcel
 
Posts: n/a
Default roundtrip mileage with one name entered in A1


here's a good start

A1 to A5 enter these values

a
b
c
d
e
B1:B5 enter this
1
2
3
4
5
C1:C5 enter this
1a
2b
3c
4d
5e
place this formula in E1
=VLOOKUP(D1,A1:C5,2)
place this formula in F1
=VLOOKUP(D1,A1:C5,3)
Now in D1 enter any value that is in column A and see what happens

You can use column A as the list for the doctors names
Colmn B you can use for another, such as the doctors address
column C will be the milage,

Let me know if you cannot get this to work for your requirements
:(


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=519191