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

Use VLOOKUP function


Gord Dibben MS Excel MVP

On Wed, 9 Apr 2008 08:17:02 -0700, 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??