Vlookup + Match that contains specific text

Hi,

I've been using vLookup and Match for a long time. Works great for exact match of text scenarios. How do I get this to work when it can't be an exact match but rather contains a specific word? Here is my formula example. Coverage is the specific word that is contained somewhere in SurveyDataRaw!$C$1:$Z$.

=IFERROR(VLOOKUP(A3,SurveyDataRaw!C:Z,MATCH("Coverage",SurveyDataRaw!$C$1:$Z$1,0),0),"")

As always, I appreciate any help. Thank you

Maybe

Formula:

Please Login or Register  to view this content.

Thank you, it works! ... well kind of.

Hmm, it seems to be working but it wasn't working on all of my columns (only difference between columns is the word I am searching for). I started to compare the differences and narrowed it down to characters in a cell. This formula works well for any cell with up to 255 characters (including spaces). As soon as a cell had 256 characters, it does not show any value. Any idea if this is expected behavior of Excel?

Yes it is, a number of functions cannot handle more that 255 characters.