+ Reply to Thread
Results 1 to 3 of 3

Auto Populate cell based on Drop Down list in another cell (VLookup)

  1. #1
    Registered User
    Join Date
    11-27-2013
    Location
    LR, AR
    MS-Off Ver
    Excel 2003
    Posts
    2

    Angry Auto Populate cell based on Drop Down list in another cell (VLookup)

    Hello Everyone,

    I know this question has been asked, but the suggested answers are not working to solve my issue. I have tried time and again to use VLOOKUP with moderate success and, after about two hours, I only just now got a value.

    What I am trying to do is have the corresponding LEA Number from the sheet called LEA Information generate in cell H6 when the district is selected from the list. As you can see from the attached workbook, the formula that I used is "=VLOOKUP(C6,LEAInformation,1,TRUE)" but the problem is that when I select a different district name from C6, the LEA number does not change and it does not correspond to the district either. Please help, I feel like an absolute imbecile.

    Attached you will find the workbook that I am dealing with:

    On Sheet 1 in cell C6 is a dropdown menu using the data range from the second sheet (LEA Information) called LEANames.

    Quick Info for sheet "LEA Information":
    • A2:261 is called LEANumbers.
    • B2:261 is called LEANames.
    • The Table Array is called LEAInformation.
    Attached Files Attached Files

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Auto Populate cell based on Drop Down list in another cell (VLookup)

    Try

    =INDEX('LEA Information'!A:A,MATCH(C6,'LEA Information'!B:B,0))

    in H6.

    VLOOKUP only works if your lookup column is on the left of the range.
    Martin

  3. #3
    Registered User
    Join Date
    11-27-2013
    Location
    LR, AR
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Auto Populate cell based on Drop Down list in another cell (VLookup)

    THANK YOU, I figured out the leftmost column of VLOOKUP right as you replied!

    I had literally been working on this for hours getting increasingly frustrated, realizing that the answer had to be simple and right in front of my face, which is what prompted my help request.

+ 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. Replies: 17
    Last Post: 02-05-2013, 08:20 PM
  2. Replies: 0
    Last Post: 01-10-2013, 06:09 PM
  3. Replies: 3
    Last Post: 02-28-2012, 11:54 AM
  4. Drop Down List Auto Populate Percentage in Different Cell
    By quantum17271 in forum Excel General
    Replies: 1
    Last Post: 11-11-2011, 06:39 PM
  5. How to populate cell based on drop-down list attached to the SAME cell?
    By lpteague in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-25-2010, 02:01 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