Hi!

Try this: (based on your sample size and data)

Array entered:

=INDEX($T$2:$T$16,SMALL(IF(MMULT(--($U$2:$Y$16=$A$2),TRANSPOSE(COLUMN($U$2:$Y$16)^0)) 0,ROW(T$2:T$16)-ROW(T$2)+1),COLUMNS($A:A)))

If you want an error trap:

=IF(COLUMNS($A:A)<=SUM(--(MMULT(--($U$2:$Y$16=$A$2),TRANSPOSE(COLUMN($U$2:$Y$16)^0)) 0)),INDEX($T$2:$T$16,SMALL(IF(MMULT(--($U$2:$Y$16=$A$2),TRANSPOSE(COLUMN($U$2:$Y$16)^0)) 0,ROW(T$2:T$16)-ROW(T$2)+1),COLUMNS($A:A))),"")

Since it may be possible for every row in the range to contain the * you
have to copy across the equivalent number of cells.

Biff

"Sam via OfficeKB.com" <u4102@uwe wrote in message
news:6334a3dc91a4e@uwe...
Hi All,

I would like to search multiple columns for criterion asterisk (*) and
Return
across a single Row Multiple Numeric Labels that MATCH the criterion on
their
respective Row.

1. The criterion is an asterisk * (multiplication sign) housed in cell A2
2. The data to be searched for criterion is housed in columns U2:Y60
3. The Numeric Labels to be returned are housed in column T2:T60
4. To search for criterion "~**" (Tilde ** in quotation marks)

Sample Data Layout:
Col"T" Col"U" Col"V" Col"W" Col"X"
Col"Y"
1
2
3 X
4 **
5
6 **
7 * **
8 X
9 **
10 *
11 * *
12 *
13
14 **
15 X


Expected Results:
Numeric Label has criterion asterisk on its row. Return Numeric Labels
across
a row :
4 6 7 9 10 11 12 14

Thanks
Sam

--
Message posted via http://www.officekb.com