I have a table like this

a b c
6.75 -.75
6.875 -1.25
7.0 -2.0
7.125 -2.125
7.375 -2.75
7.5 -3.0

Everything works fine on my spreadsheet until I change from 7 to 7.125. It
returns the same value(-2.0). I don't know what I am doing wrong. Please help.
Landon

Could you post your formula? Are you sure the table range covers the
whole of your data?

Pete

Thanks for the reply. Here is the formula. It is linked to another workbook.
I put this on sharepoint which is on a server.I am still getting the same
result on 7 and 7.125. The c colume has different numbers. Thanks again
Landon

=LOOKUP(H8*100,'http://www.hhpmortgage.net/Shared%20Documents/[todays_rates.xls]todays_rates'!$A$774:$A$793,'http://www.hhpmortgage.net/Shared%20Documents/[todays_rates.xls]todays_rates'!$C$774:$C$793)

"Pete_UK" wrote:

Could you post your formula? Are you sure the table range covers the
whole of your data?

Pete

Hi Landon,

I think Pete nailed your problem. The table should be something like:

$A$1:$C$6 and you have

A1:C6

HTH
Regards,
Howard

"Landon C" wrote in message
...
I have a table like this

a b c
6.75 -.75
6.875 -1.25
7.0 -2.0
7.125 -2.125
7.375 -2.75
7.5 -3.0

Everything works fine on my spreadsheet until I change from 7 to 7.125. It
returns the same value(-2.0). I don't know what I am doing wrong. Please
help.
Landon

Thanks,
I posted the formula on Petes reply. Take a look and tell me if the problem
could be on the data side. I download the excel sheet from a lender.
Thanks

"L. Howard Kittle" wrote:

Hi Landon,

I think Pete nailed your problem. The table should be something like:

$A$1:$C$6 and you have

A1:C6

HTH
Regards,
Howard

"Landon C" wrote in message
...
I have a table like this

a b c
6.75 -.75
6.875 -1.25
7.0 -2.0
7.125 -2.125
7.375 -2.75
7.5 -3.0

Everything works fine on my spreadsheet until I change from 7 to 7.125. It
returns the same value(-2.0). I don't know what I am doing wrong. Please
help.
Landon