Autofill a column based on text in adjacent column

HPCDNK

New member
Joined
Apr 10, 2013
Messages
1
Reaction score
0
Points
0
Hey. I am new to this site and have very little experience on excel. I am trying to update a mileage expense report for my boss. When she fills in a farm name in column D she wants the mileage to auto fill into column G. The mileage is set and doesn't vary. For example the mileage for Farm A is always 145.3 miles and the the mileage for Farm B is 97.6 miles, etc. I hope that all makes sense. Any help would be greatly appreciated!

Column D........Column G
Farm A ..........145.3
Farm C ..........76.5
Farm B...........97.6
Farm C ..........76.6
 
Top