Match strings of characters & return content
Solved/Closed
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!
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!
Related:
- Match strings of characters & return content
- Need for speed: most wanted 2005 downloadable content - Download - Racing
- Summertime saga downloadable content - Download - Adult games
- Efootball 2022 downloadable content - Download - Sports
- Fifa 23 downloadable content - Download - Sports
- Gta v downloadable content - Download - Action and adventure
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 16, 2010 at 06:30 PM
Jun 16, 2010 at 06:30 PM
you can use index, or indirect functions
Jun 17, 2010 at 10:45 AM
Jun 17, 2010 at 11:36 AM
Jun 17, 2010 at 11:46 AM
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..
Jun 17, 2010 at 01:31 PM
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!!
Jun 17, 2010 at 01:50 PM
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