Results 1 to 2 of 2

Thread: Autofill a column based on text in adjacent column

  1. #1

    Autofill a column based on text in adjacent column

    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

  2. #2
    Conjurer royUK's Avatar
    Join Date
    Mar 2011
    Derbyshire, UK
    Excel Version
    most versions
    You should be able to use VLOOKUP to do that
    Hope that helps


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts