+ Reply to Thread
Results 1 to 3 of 3

using two drop downs to specify value and named range for vlook up ref.

  1. #1
    Registered User
    Join Date
    12-07-2015
    Location
    US
    MS-Off Ver
    12.3.6 for mac
    Posts
    13

    using two drop downs to specify value and named range for vlook up ref.

    i have attached my sheet. I want to select the class which in turn will produce a name of the range next to it. With that named range I would like to look up the value in corresponding cells with V look up function. Is there a way to have vlookup look for the name selected in cell C2 with in the range that will appear in cell B2 and change dynamically when ever a new student is selected?
    Thank you for the read and the help

    jim
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    Re: using two drop downs to specify value and named range for vlook up ref.

    You almost had it

    =VLOOKUP($C$2,INDIRECT($B$2),2,FALSE)

  3. #3
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: using two drop downs to specify value and named range for vlook up ref.

    Try this

    =VLOOKUP($C$2,INDIRECT($B2),MATCH(E$1,StudentsScores!$A$1:$G$1,0),FALSE)
    and copy down and right
    Formula: copy to clipboard
    Please Login or Register  to view this content.



    Regards

+ 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] Drop Downs conditional on drop downs
    By BillTD in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-06-2015, 09:40 AM
  2. Replies: 0
    Last Post: 02-21-2014, 04:01 PM
  3. Multiple drop dependant drop downs in single cell
    By LittleJerry in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-07-2012, 02:21 PM
  4. Change input range of 50+ drop downs
    By Kazstankgardner in forum Excel General
    Replies: 3
    Last Post: 06-19-2012, 07:54 AM
  5. Auto-update initial drop-down selection based on previous drop-downs
    By thornomad in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-16-2010, 09:55 AM
  6. Use Drop Downs to Populate Other Drop Downs
    By fbombs in forum Excel General
    Replies: 2
    Last Post: 09-23-2009, 03:17 PM
  7. [SOLVED] Data validation drop downs don't recognize dynamic named range
    By GlenC in forum Excel General
    Replies: 0
    Last Post: 07-19-2006, 01: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