+ Reply to Thread
Results 1 to 2 of 2

Need Drop-Down Selection to Auto-Populates Data in Adjacent Cell

  1. #1
    Registered User
    Join Date
    05-18-2016
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    15

    Need Drop-Down Selection to Auto-Populates Data in Adjacent Cell

    The attached workbook has 2 tabs... 1st is my main form tab and 2nd is the drop-down options tab. On 'QA Form' tab, I have cells in which I can select a drop-down option (column B). I am needing the data from the adjacent cell of the drop-down selection (example = C2, What was Reviewed, of the QA Form tab) to auto-populate the data found in the cell next to the corresponding Category on the Drop-Down Options tab.

    My apologies in advance for the terrible explanation, but any assistance would be appreciated.

    Prodetik
    Attached Files Attached Files

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,147

    Re: Need Drop-Down Selection to Auto-Populates Data in Adjacent Cell

    use a VLOOKUP.
    =VLOOKUP(B2,'Drop-Down Options'!A:B,2,0)

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

+ 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] Making a table that auto populates based on adjacent cells
    By leonidasbell in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-12-2016, 10:23 AM
  2. Drop down list that auto populates appropriate cell
    By JKropetz in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-15-2015, 02:17 PM
  3. Replies: 7
    Last Post: 02-06-2014, 07:40 AM
  4. Replies: 3
    Last Post: 09-17-2013, 10:45 PM
  5. How to Auto Fetch row data upon drop down selection in a cell.
    By ankit-jain in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-07-2013, 06:27 PM
  6. Named range populates after drop down selection
    By hwtcrl in forum Excel General
    Replies: 0
    Last Post: 02-06-2013, 10:49 AM
  7. drop down menu selection populates column values
    By rebe29cca in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-29-2011, 06:33 PM

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