Search row for value with * and return that value?

gms4b 

There are so many possibilities!

Some start with searching each heading of a table for a sub-string, for example "Peak Area" or "Concentration"

= SEARCH( "Concentration", Table1[#Headers] )

That returns an array of numbers and #VALUE! errors for matches and non-matches respectively.

From there

= LOOKUP( 1, SIGN( SEARCH( "Concentration", Table1[#Headers] ) ), Table1[#Headers] )

would return the matched heading (or the final match if there are more than one).

In future another function that would return one or more matches is FILTER, 

= FILTER( Table1[#Headers], ISNUMBER( SEARCH( "Concentration", Table1[#Headers] ) ) )

A further trick that FILTER offers is to return the entire data column associated with the matched heading

= FILTER( Table1, ISNUMBER( SEARCH( "Concentration", Table1[#Headers] ) ) )