VictoriaExcel
New Member
- Joined
- Nov 15, 2018
- Messages
- 14
Hi,
I need to search for a match between a range of text and strings of data in a table. If a match is found then I wish to return that match into the next column.
I have tried this formula =IF(ISNUMBER(SEARCH(Schools,[@Tags])),Schools,"") but it will only return data for cells on the same rows as the match with the range.
More details below ...
Range named 'Schools' on separate sheet (what is being searched for and also what should be returned:
<tbody>
</tbody>Many thanks in advance,
Victoria
I need to search for a match between a range of text and strings of data in a table. If a match is found then I wish to return that match into the next column.
I have tried this formula =IF(ISNUMBER(SEARCH(Schools,[@Tags])),Schools,"") but it will only return data for cells on the same rows as the match with the range.
More details below ...
Range named 'Schools' on separate sheet (what is being searched for and also what should be returned:
School of Art Architecture & Design | |||||
School of Built Environment & Engineering | |||||
Carnegie School of Education | |||||
Carnegie School of Sport | |||||
School of Clinical & Applied Sciences | |||||
School of Computing Creative Technologies & Engineering | |||||
School of Cultural Studies & Humanities | |||||
Department of Languages | |||||
School of Events Tourism & Hospitality Management | |||||
School of Film Music & Performing Arts | |||||
School of Health & Community Studies | |||||
Leeds Business School | |||||
Leeds Law School | |||||
Leeds School of Social Sciences Example strings of text from 5 of 33,522 rows:
<tbody> </tbody> |
<tbody>
</tbody>
Victoria