View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
gavinhoffman gavinhoffman is offline
external usenet poster
 
Posts: 2
Default list problems......

Hello there
I am creating a sheet that calculates mileage. I have created a drop down
list cell from a colunm of destinations

(which has a column of corresponding mileage beside it).
I want to able to choose an option from the drop down list cell and want
the mileage to appear in the cell beside

for calculations. how do i do this??