Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
a formula to search for names in columns and then add the figures | Excel Worksheet Functions | |||
Macros search for names | Excel Discussion (Misc queries) | |||
Search worksheet names? | Excel Discussion (Misc queries) | |||
Can I search sheet tabs for names? | Excel Discussion (Misc queries) | |||
Move names from Search to Excel | Excel Discussion (Misc queries) |