Assuming your data from A1 to F11, and your criteria start from A15 and
"BOX050"

=INDEX($A$1:$F$11,MATCH("BOX050",$A$1:$F$1,"0),MAT CH($A15,$A$1:$A$11,0))


"carl" wrote:

My data table is like this:

BOX005 BOX009 BOX017 BOX050 BOX060
BOX005 30
BOX009
BOX017 430 81
BOX050 30 81 546 46
BOX060 46
BOX074 20
BOX226 15 5
BOX233
BOX325
BOX333 7 56

Is it possible, on another sheet to do the following:

In a cell, enter one of the values in row 1 above and then have a table fill
in like this (in this case BOX050 was entered):

BOX050 546
BOX017 81
BOX333 56
BOX060 46
BOX005 30
BOX074 20
BOX226 5
BOX009
BOX233
BOX325

So BOX050 was entered and the new table displayed the column with BOX050 in
row1 in a decending sort.

I hope I explained this clear enough.

Thank you in advance.