Build a Dynamic Named Range from criteria.

Hello Forum.

I have some raw data, and in that data are 2 columns. They are Manager and Role. I am trying to create 2 lists, that correspond to their role. I can create a dynamic named range from the column no problem using this formula:

Formula:

=OFFSET($A$1,0,0,MATCH("*",$A:$A,-1),1)

Now, what I need to be able to do is, add a criteria option to the formula. So build the list off of column B, but only if their role (in column C) is Perm, or Temp.

Please see the attached spreadsheet.