I'm trying to create a dynamic named range based on two criteria in different columns. My data set is A4:AQ5000 in a sheet called "CS". Column C is "Description", column V is called "Family" and column W is called "Product". I want to create a named range called "Smith" of the descriptions in column C where column V is "Smith" and column W is "Accessory". 
  Row          Column C          Column V     Column W
                  Description        Family          Product

      1           5m Cable           Smith          Accessory
      2           2m  Table          John            Base 
      36         1m Extension     Red             Accessory
      44         20m Cable         John            Accessory
      129       2.5m  Table        Smith         Accessory
      300       1.2m Extension   Smith         Accessory
Every row has data but I have purposely tried to show the family and product can be in any row from 4 to 5000.

Thanks in advance.