Hello Harlan,
Let's say the Worksheet is called "Numbers" and I wanted the information
on a separate sheet called "String" and start with row B1 and continue to B2,
B3, B4, etc.

So it would look like:
A B C D E F G
6 002 015 102 034 008 048 076

Would the formula look like:
=INDEX(NUmbers!A1:C5,INT(SMALL(IF(COUNTIF(OFFSET(N umbers!A1:C5,ROW(Numbers!A1:C5)-CELL"Row",Numbers!A1:C5),0,1,),A6)
*(Numbers!A1:C5<A6)0,(ROW(Numbers!A1:C5)*100000+ COLUMN(Numbers!A1:C5))),COLUMNS($B1:B1))/100000),MOD(SMALL(IF(COUNTIF(OFFSET(Numbers!A1:C5, ROW(Numbers!A1:C5)-CELL("Row",Numbers!A1:C5),0,1,),A6)*(Numbers!A1:C5 <A6)0,(ROW(NumbersA1:C5)*100000+COLUMN(Numbers!A 1:C5))),COLUMNS($B1:B1)),100000))

Where A6 is the equal of v and the location "Numbers!A1:C5" is equal to Tbl?

Thank you for your assistance.


"Harlan Grove" wrote:

David wrote...
I have a column of numbers such as

A B C
1 002 015 102
2 034 002 008
3 015 048 120
4 076 005 008
5 002 048 076
....

I'll assume this table is named Tbl.

So if I put 002. I would get a return of 015, 102, 034, 008, 048, 076.
If I did 015 I would get a return of 002, 102, 048, 120.
....

If you enter the number to match in a cell named v, then you could use
the following array formula with the first result in cell E1.

E1 [array formula]:
=INDEX(Tbl,INT(SMALL(IF(COUNTIF(OFFSET(Tbl,ROW(Tbl )-CELL("Row",Tbl),0,1,),v)
*(Tbl<v)0,(ROW(Tbl)*100000+COLUMN(Tbl))),COLUMNS ($E1:E1))/100000),
MOD(SMALL(IF(COUNTIF(OFFSET(Tbl,ROW(Tbl)-CELL("Row",Tbl),0,1,),v)*(Tbl<v)0,
(ROW(Tbl)*100000+COLUMN(Tbl))),COLUMNS($E1:E1)),10 0000))

Fill right as far as needed.