LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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?


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
a formula to search for names in columns and then add the figures Vercingetorix.I Excel Worksheet Functions 5 August 23rd 08 11:22 PM
Macros search for names gwtechie72 Excel Discussion (Misc queries) 3 October 5th 07 07:50 PM
Search worksheet names? J@Y Excel Discussion (Misc queries) 4 February 1st 07 06:59 PM
Can I search sheet tabs for names? kellerwynn7 Excel Discussion (Misc queries) 3 January 31st 07 08:54 PM
Move names from Search to Excel Mark1 Excel Discussion (Misc queries) 5 October 27th 06 07:54 PM


All times are GMT +1. The time now is 11:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"