View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tommcbrny tommcbrny is offline
external usenet poster
 
Posts: 57
Default 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?