with list in column as per Marvin's post:

=INDEX(PAYEES!$B$1:$B$27,SUMPRODUCT(--(ISNUMBER(SEARCH(PAYEES!$A$1:$A$27,C1)))*ROW($A$1:$A$27)))

List does not need to be sorted.