+ Reply to Thread
Results 1 to 4 of 4

Trying to auto populate a cell based on the value on another selected from drop list

  1. #1
    Registered User
    Join Date
    01-27-2015
    Location
    Phoenix, AZ
    MS-Off Ver
    MS Office 2013
    Posts
    2

    Trying to auto populate a cell based on the value on another selected from drop list

    I have am working within a workbook.

    On sheet named DATA column A I have listed each of the health benefit plans offered. In column B I have listed the corresponding weekly employee cost for each plan.

    On sheet named 1.24.15 Column A and B are Employee First and Last Names. Column M I have created a drop down list where I can select from the list of plans. I want to auto populate Column N with the corresponding weekly payroll deduction based on the Plan selection I make in column M.

    I am a not a beginner but still a basic user and I tried to google options for this desired result. I found and tried the following but ended up with: #NA error. =VLOOKUP(M2,DATA!A2:B5,2,FALSE)

    I am using Excel 2013.

    Thank you for any help you can provide.

  2. #2
    Forum Contributor
    Join Date
    11-02-2011
    Location
    Rugby, England
    MS-Off Ver
    Office 365
    Posts
    846

    Re: Trying to auto populate a cell based on the value on another selected from drop list

    Hi, loading a sample worksheet may help you get your result

  3. #3
    Registered User
    Join Date
    06-04-2014
    Posts
    13

    Re: Trying to auto populate a cell based on the value on another selected from drop list

    Lmarci,

    I tried to duplicate what you said and hopefully this helps. I first highlighted the benefits (A2:A?) then named that range Benefits. Then I highlighted (A2:B?) and named that range BenfitCost. In Column M for to create the drop down list of benefits I inserted the range name Benefits. In Column N (for example N2) I put in this formula =IFERROR(VLOOKUP($M3,BenefitCost,2,FALSE),"") hopefully this helps.Benefit Plans.xlsxthere's the file if you need to look at it.

  4. #4
    Registered User
    Join Date
    01-27-2015
    Location
    Phoenix, AZ
    MS-Off Ver
    MS Office 2013
    Posts
    2

    Re: Trying to auto populate a cell based on the value on another selected from drop list

    Hello RussB,
    I opened your file and it works great, however, I must say that when I first followed the instructions and highlighted/named the (BenefitCost) range I didn't grab both (A2:B12) and instead only grabbed B2:B12. Everything else was exactly as you had directed me and I was going nuts trying to figure why my Column N wasn't populating anything and yet your sheet worked fine. I finally checked your range names and focused on which ranges would highlight as I clicked on the range name..and there it was!! I found my error.
    I thank you so much, this has been a huge help and will eliminate keystroking errors in Column N going forward.
    :-) Lmarci

+ 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. Auto Populate cell based on Drop Down list in another cell (VLookup)
    By alialmoore in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-27-2013, 04:07 PM
  2. [SOLVED] When drop down is selected I want text from another list to populate different cell
    By slowride in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-27-2013, 01:17 AM
  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. auto populate cell when selected drop down item chosen
    By palmer19 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-13-2010, 07:16 AM

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