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.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks