Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
94
Views
Topic starter
Attached is the excel file with public viewing and a .png. Thanks.
Posted : 15/09/2019 3:31 pm
Hi John,
Welcome to our forum. Give the cells C5:C13 the name 'List'. then use this formula in cell B5 and copy down:
=INDEX($C$5:$D$13,IF(SUMPRODUCT(--ISNUMBER(SEARCH(List,A5)))<>0,SUMPRODUCT(ISNUMBER(SEARCH(List,A5))*ROW($1:$9)),NA()),2)
The formula will return #N/A where there is no match found.
It is based on this example of searching a list of words for a text string.
Mynda
Posted : 16/09/2019 7:56 pm
