Drop down menus and functions problem

[pyzikchr]

I am creating a mileage expense form for work. I have set the form u
so that the starting points and destinations are drop down menus i
their respective cells. The problem I am having is that when th
starting point and the destination are selected I would like th
mileage traveled to show up in the cell next to it. I have created
table of the mileages, but I have no clue how to use the functions t
have the drop down menus to correspond to the mileages on the chart

 

[jeff]

Hi,

How about having a hidden column that combines your
start and destinations beside your mileages. then you
can use a VLookup formula to plug in the values
(Vlookup(A3&B3,C1:C20,1)) :

e.g.
Start Destination (Hidden) Mileage
Columbus Cincinnati ColumbusCincinnati 150
Newark Boston NewarkBoston 450

jeff

 

[Frank Kabel]

Hi
sounds like you need VLOOKUP. See:
http://www.mvps.org/dmcritchie/excel/vlookup.htm