Search for names

T

tommcbrny

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top