Try something like this:

With
Your current data table on Sheet1, cells A1:J7

Then
On Sheet2
A1: 1.01
A2: =+A1+0.01
(copy that formula down as far as you need)

B1:
=VLOOKUP(INT(A1*10)/10,Sheet1!$A$1:$J$7,MATCH(ROUND(MOD(A1,0.1),2),She et1!$A$1:$J$1,0),0)
(copy that formula down as far as you need)

Then...copy the new data table range
<edit<paste special
.....Check: Values
.....Click [OK]


Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"TDS" wrote:

I have data like this:
.01 .02 .03 .04 .05 .06 .07 .08 .09
1.0 2.0 2.15 2.3 2.7 3.0 3.26 3.40 3.61 3.89
1.1 3.94
1.2
1.3
1.4
1.5
Etc... this is a basic table to figure the greater number (1st column) +
the lesser number (the 1st row) ...the find the array value @ A3:C3. I need
to convert this a 2-column file such as:

1.01 2.0
1.02 2.15
1.03 2.3
1.04 2.7
1.05 3.0
etc.

Hope this is enough info...

Basically it is an array for figuring flow of water...if I know how high the
creek is flowing, I can figure how many cfs it is passing. So, if I know
it's 2.45 ft...then the table would figure xx.xxx cfs. But in order to bring
it into another program I have to have it in a 2-column list.

Thanks!