This is a follow up to a post that I submitted here a few days ago. T. Valko
gave me a great function and tried, repeatedly, to help me (thanks for the
assistance). No matter what I did, I just couldnt get the function working
the way I needed it to work. Thus, I am back with a similar request. I am
hoping someone can give me a function to return the cell address for all
items in a list that match a certain criteria. I am thinking of something
such as this:
=ADDRESS(MATCH(A2,'Import Sheet'!A2:A65000,0),1)

This works, but the value in A2 must be an exact match with the value in the
list (which is 'Import Sheet'!A2:A65000). I know this comes from the
€˜match_type in MATCH(lookup_value,lookup_array,match_type)

The problem is that the value in A2 will be a name, but the values in the
list in 'Import Sheet'!A2:A65000, are names, combined with spaces before and
after the names, commas before and after the names, hyphens before and after
the names, etc. Since the data will never be an EXACT MATCH, I cant do the
match. Im thinking the SEARCH function will be the best function to use
because it does not rely on case sensitive data. A function or a macro would
be great!!

Does anyone have any insight about this?

Cordially,
Ryan--



--
RyGuy