Get column and row names

Hi Guys

I have a engineering project that requires me to lookup a value in a table (10 rows, 5 columns) of data and return the column and row names. I have found allot of formulas on the internet but all of them require the column and row to get the cell value where I need it to be the other way arround.

Need help plzzzzzzz!

This is the table below. The value in C20 must be compared to the table above and from that it must return all the the column names and row names where it finds the nerest match that is bigger.

eg. If c20 is 386.9 that the formula must return 8,8 5,10 4,12 and so on.

Perhaps this array formula filled across the sheet for 10 columns...

D$6&", "&INDEX($B$7:$B$15,MATCH(MIN(IF(D$7:D$15>=$C$20,D$7:D$15,"")),D$7:D$15,0))

Change the ">=" to ">" if you really want to reject an exact match.

Beau Nydal