Search for names
 

Hi,

I have a list, "sponsor", with several names in it. I have rows of data
where names appear in some cells (for instance, d1, e1, f1, g1, h1 have
names). The names do not repeat in a row. Some names in the data will not
be in my "sponsor" list. If one name from my "sponsor" list is in a row, no
other names from that list will be in the row.

Can I search each row for names in the list and, if found, print the name to
a target cell?