Hello - I have data in columns A1:PQ1 and I need to find the position of several different letter/number combinations in the array. For example, when I use:
=MATCH("XVALS"&"*",$A$1:$PQ$1,0)
it returns 33 (corresponding to AG1). For the next search I can change $A$1 to $AE$1, but this...