excel - How can I create a formula from drop down list -

hello need getting right formula need.

i need able have drop down list in 1 cell , formula in next cell works out value.

for example in 1 cell drop down list contain >15, 15-20,20-25,25-30 , on. shows how many miles employee has travelled. i'd next cell state figure each option of drop down example 15-20 miles = £4.75.

any idea's on how calculate helpful , forever in debt

laura

you need use vlookup formula.

let cell a1 contains drop down menu (created data->validation->list selecting source in case b1:b3).

let b1:b3 contain miles, 10,20,30

let c1:c3 contain costs, £1.00, £2.00, £3.00

in d1 can type =vlookup($a$1,$b$1:$c$3,2,false). should display in d1 cost mileage selected in a1.

hope helps.