Results 1 to 4 of 4

Named Range - Data Validation List

Threaded View

  1. #1
    Forum Contributor Tarball's Avatar
    Join Date
    04-21-2007
    Location
    Atlanta, GA
    Posts
    166

    Named Range - Data Validation List

    I have a named range that includes columns A, B, C, and D - Called QB. The name of the tab which the data lives on is also called QB.

    In another sheet, I have a data validation list in a column titled "Position" with the following entries: QB, RB, WR, K, DST, TE.

    Next to the Position column is the Player column. When the user selects a position from the drop down list, the Player column is populated with a data validation list of all the players from the selected position (the data validation used INDIRECT to populate the list).

    I want to use VLOOKUPs to populate other columns such as Bye, Salary, and Team based on the named ranges (which I know how to do).

    The problem is, how do I limit the lookup of the "Player" so that the player validation list does not list all of the columns in the named range?
    Attached Images Attached Images
    Last edited by Tarball; 07-28-2010 at 12:38 PM.
    Reach me at excel_help at bellsouth dot net

Thread Information

Users Browsing this Thread

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

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