Using Index and Match to search an array that has multiple items in each cell

Hi.

Welcome to the forum.

Try putting an asterisk either side of your search string:

=INDEX('Stress Index'!$C$10:$U$76,MATCH("*"&T3&"*",'Stress Index'!$U$10:$U$76,0),1)

Cheers, Rob.

Damn! Beaten on the draw again. :P