Match strings of characters & return content

Solved/Closed
-
 maggs -
Hello,


I was able to define this formula to return the row in which the match content was found:

=MATCH("*"&MID($B2&REPT(CHAR(6),6),(ROW(OFFSET($A$1,0,0,LEN($B2),1))),6)&"*",$A:$A,0)

Is there a way to return the actual content?

Thanks!

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
you can use index, or indirect functions
the indirect function worked. THANK YOU!!!
Is there a way to return more than one value if more than one match is found? Thanks!
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Match will show the first hit (if any) You may want to create your own function to do multiple matches

What exactly are you trying to do. May be there is some other way too if only a little more is known about what is the objective..
I am trying to locate and remove duplicates customer accounts by matching address information from a current property list against all existing customer accounts. I am searching a list of 800 properties against 30,000 accounts.

Column A: addresses for all existing accounts, 30,000 records
Column B: address nee to search, 800 records

Column A may contain more than one match for Column B.

Thanks so much for your help!!
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
I am very confused over what you want. If you want to see a duplication, so as soon as a match is found, we know that it is a duplicate. Are you saying on in column A (30000) there is an address that will appear more than once in column B (800)

May be if you could put up some sort of sample file and then explain the issue that you are trying to resolve. Could you please upload a sample file with sample data etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too