list cell 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??

list cell problems......
 

Use VLOOKUP()
--
Gary''s Student - gsnu200778


"gavinhoffman" wrote:

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??