+ Reply to Thread
Results 1 to 2 of 2

auto populate text in a cell when a drop down selection is made

  1. #1
    Registered User
    Join Date
    10-06-2020
    Location
    Hilton
    MS-Off Ver
    2010
    Posts
    1

    Post auto populate text in a cell when a drop down selection is made

    Good evening,

    Looking for some help. I have created an audit template and we have to complete certain checks set by myself weekly. i thought i would enter all the values and corresponding text into excel. i have 2 columns the first the the check number and column 2 is the text.
    I would like to select the number on another sheet and the text to auto populate. I have tried to use vlookup but cant seem to get it working. Is this the correct formula to use or is it me just getting the formula wrong.

    Think i need some assistance on this one.

    Thanks in advance

    Regards
    ]
    Mark

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    33,843

    Re: auto populate text in a cell when a drop down selection is made

    VLOOKUP is a likely candidate. INDEX/MATCH is an alternative approach. Or, if the check numbers are numeric, you could maybe use INDEX.

    Suggest you post a sample workbook.
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Auto-populate Column based on Drop-down Selection
    By g.costapinto in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-13-2019, 06:29 AM
  2. How to Auto populate via drop down selection
    By Albert Truncation in forum Excel General
    Replies: 5
    Last Post: 06-25-2019, 09:56 PM
  3. [SOLVED] Auto-populate fields based on drop down selection
    By kwo in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-23-2015, 07:15 AM
  4. Auto Populate cells based on Drop-down selection
    By stepzuko in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-11-2014, 03:02 PM
  5. drop down selection to auto populate multiple cells
    By chika90 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-03-2013, 10:08 AM
  6. Auto-populate field based on drop down box selection
    By nicfarrell in forum Excel General
    Replies: 7
    Last Post: 01-21-2013, 12:47 AM
  7. [SOLVED] Auto populate several cells based on a selection from drop down li
    By Sheldon in forum Excel General
    Replies: 3
    Last Post: 01-13-2006, 04:30 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1