I have a lookup table and I want a defined range name that returns
only those records where ACTIVE = "Y"
I am using this defined name in a field data validation with a list
dropdown.

Table Structure with 4 fields, Column A,B,C, and D.
Ltype LTypeSh LicFee LicActive
Add-on Apr08 Add Apr08 550 N
Add-on Jan08 Add Jan08 500 Y
Tmp1 Apr08 T1 Apr08 10500 N
Tmp1 Jan08 T1 Jan08 10000 Y


This formula does NOT work to return the 2 active records I expect
where the LicActive field = "Y".
Name Define: LicRec
OFFSET(Lists!$B$2,0,0,COUNTIF(Lists!$D:$D,"='Y'"), 1)

This formula DOES return all and only the 4 records
Name Define: LicRec
OFFSET(Lists!$B$2,0,0,COUNTIF(Lists!$D:$D,"a'"),1 )

Any thoughts would be appreciated,
Dennis