Multiple Lookup/DropDown

[FLHR01]

Hello,

I would like to create a drop down that is based on the value of another cell.

[6StringJazzer]

Attaching a Word file with screenshots is not useful. Please attach your actual Excel file.

[FLHR01]

Here is the excel file

[6StringJazzer]

Create a new named formula called JobList

=OFFSET('HOME POSITION'!$A$1,1,MATCH('New Hire'!$F$2,'HOME POSITION'!$1:$1,0)-1,COUNTA(OFFSET('HOME POSITION'!$A$1,1,MATCH('New Hire'!$F$2,'HOME POSITION'!$1:$1,0)-1,99,1),1))

In cell B4, use Data Validation with a List, and use the formula

=JobList

[FLHR01]

SOLVED!!!!

http://www.excel-university.com/crea...ta-validation/

[FLHR01]

Ok...I am tweaking my drop down list and trying to get it to only show cells in the drop down that have a value (skipping blanks)
using the formula from

http://www.excel-university.com/crea...ta-validation/

I DID get it to work for "New Hire" but can't get it to work for Changes (I haven't tried the other 3 tabs)

[FLHR01]

Each form & position cell require their own dd_col and dd_col_num