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?

If you want help with Excel attach a workbook not an image

Originally Posted by Tarball

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?

At the absolute least, we would have to see the formula using Indirect(), but a workbook would be better.

Thanks for the help. I did actually figure it out by using 2 named ranges and a standardized naming convention. I can specify the specific set of players using the position value from the first drop down so that the VLOOKUP is now dependent on the selection. For Example:

Selecting the position "QB" (for Quarterback) drives a VLOOKUP based on a second named range called "QB_2"

Please Login or Register  to view this content.