Biff's formula can be modified as follows...

B2, copied across:

=IF(COLUMNS($B2:B2)<=SUM(--(MMULT(ISNUMBER(FIND($A2,$U$2:$Y$16))+0,TRANSP
OSE(COLUMN($U$2:$Y$16)^0))0)),INDEX($T$2:$T$16,SM ALL(IF(MMULT(ISNUMBER(F
IND($A2,$U$2:$Y$16))+0,TRANSPOSE(COLUMN($U$2:$Y$16 )^0)),ROW($T$2:$T$16)-R
OW($T$2)+1),COLUMNS($B2:B2))),"")

A few notes:

1) It assumes that A2 contains the criterion.

2) Any cell within U2:Y16 that contains the value in A2 within its text
string will meet the criterion.

3) The function FIND is case-sensitive.

4) You may want to use a defined name for the MMULT part of the formula.
Post back if you need help...

Hope this helps!

In article <633c0fc142fff@uwe, "Sam via OfficeKB.com" <u4102@uwe
wrote:

Hi Domenic,

Correction:
Criterion is multiple asteriks
4. To search for criterion "~**" (Tilde ** in quotation marks)

If so, does this mean that while your criterion is one asterisk that you'd
like to return the numeric labels
for any row whose cells contain one or two asterisks?

Yes

Cheers,
Sam