planetsair
New Member
- Joined
- Jan 19, 2012
- Messages
- 42
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hello
I have been searching for an answer but as yet have not managed to find quite the right solution, so I’m hoping someone here may be able to help me, please J
I am wanting to search (using a partial text) through a list of data (held in sheet 2) and have a formula return a list (in sheet 1) of all the ‘words’ from sheet 2 which contain that searched for text, and also their ID
Hopefully the example below will be a bit more explanatory !
In sheet 1 – I am wanting to search for CDE in sheet 2 column A,
I am wanting a list of results to show ALL the occurrences of “CDE” from sheet 2 column A
I am also wanting to have the matching ID be shown in sheet 1 column B
<tbody>
</tbody>
I don’t know if this is relevant but in reality the text will be about 20-30 characters in length and the search criteria will also be over 15 characters (rather than the ‘CDE’ shown here)
Thanks for your help in advance
Sarah
I have been searching for an answer but as yet have not managed to find quite the right solution, so I’m hoping someone here may be able to help me, please J
I am wanting to search (using a partial text) through a list of data (held in sheet 2) and have a formula return a list (in sheet 1) of all the ‘words’ from sheet 2 which contain that searched for text, and also their ID
Hopefully the example below will be a bit more explanatory !
In sheet 1 – I am wanting to search for CDE in sheet 2 column A,
I am wanting a list of results to show ALL the occurrences of “CDE” from sheet 2 column A
I am also wanting to have the matching ID be shown in sheet 1 column B
sheet 1 | sheet 2 | |||||||
a | b | a | b | |||||
1 | Search | 1 | TEXT | ID | ||||
2 | CDE | 2 | ABCDEFGHI | SK001 | ||||
3 | 3 | HYTGREBYD | SK002 | |||||
4 | results | 4 | BCGHGICDA | SK003 | ||||
5 | TEXT | ID | 5 | CDEGHYTEGT | SK004 | |||
6 | ABCDEFGHI | SK001 | 6 | HYTSBHFR | SK005 | |||
7 | CDEGHYTEGT | SK004 |
<tbody>
</tbody>
I don’t know if this is relevant but in reality the text will be about 20-30 characters in length and the search criteria will also be over 15 characters (rather than the ‘CDE’ shown here)
Thanks for your help in advance
Sarah