I know this is probably so simple that I'm just being dense, but here is my problem

I have 2 defined names "Category" and "Reference_Name" in a worksheet.

On a different worksheet, same workbook, I want to validate Reference_Name based on a specific "Category"

I created a second Defined Name called Test =IF(Category="Special",Reference_Name,"")

When I evaluate the Definded Name "Test" i get a return of the Reference Names I want plus a lot of empties (i.e. "","",""). I thought if I select Ignore Blank in the data validation for the new worksheet I would get a dropdown list of just the Reference_Names that fall into that category, but alas I get an error.

Defined Names:
Reference_Name =cus_list!$A$4:$A$270
Category =cus_list!$C$4:$C$270

Test =IF(Category="Special",Reference_Name,"")