how to get a cell to have a data value depending on what is selected from a drop down

ok ladies and gentlemen total novice here.

im trying to speed up my mileage document, i only travel to a few different offices and so would like to be able to choose the place i visited from a drop down menu and then the milage to that place to automatically appear in the next cell.

i have attached a what i have been playing with.

any help on this would be much appriciated.

many thanks

try vlookup in B4 and copy down

=VLOOKUP(A4,$E$4:$F$7,2,FALSE)

wrapped in an IF statement to trap error messages for blank cells

=IF(A4<>"",VLOOKUP(A4,$E$4:$F$7,2,FALSE),"")

Hi adam.dixon,
welcome to the forum
try.. this in B4 and fill down =IF(ISNUMBER(MATCH(A4,E$4:E$7)),INDEX(F$4:F$7,MATCH(A4,E$4:E$7)),"")

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save