software

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?

PeteHi 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

quot;Landon Cquot; gt; wrote in message
...
gt;I have a table like this
gt;
gt; a b c
gt; 6.75 -.75
gt; 6.875 -1.25
gt; 7.0 -2.0
gt; 7.125 -2.125
gt; 7.375 -2.75
gt; 7.5 -3.0
gt;
gt; Everything works fine on my spreadsheet until I change from 7 to 7.125. It
gt; returns the same value(-2.0). I don't know what I am doing wrong. Please
gt; help.
gt; Landon
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,'www.hhpmortgage.net/Shared Documents/[todays_rates.xls]todays_rates'!$A$774:$A$793,'www.hhpmortgage.net/Shared Documents/[todays_rates.xls]todays_rates'!$C$774:$C$793)

quot;Pete_UKquot; wrote:

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

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

quot;L. Howard Kittlequot; wrote:

gt; Hi Landon,
gt;
gt; I think Pete nailed your problem. The table should be something like:
gt;
gt; $A$1:$C$6 and you have
gt;
gt; A1:C6
gt;
gt; HTH
gt; Regards,
gt; Howard
gt;
gt; quot;Landon Cquot; gt; wrote in message
gt; ...
gt; gt;I have a table like this
gt; gt;
gt; gt; a b c
gt; gt; 6.75 -.75
gt; gt; 6.875 -1.25
gt; gt; 7.0 -2.0
gt; gt; 7.125 -2.125
gt; gt; 7.375 -2.75
gt; gt; 7.5 -3.0
gt; gt;
gt; gt; Everything works fine on my spreadsheet until I change from 7 to 7.125. It
gt; gt; returns the same value(-2.0). I don't know what I am doing wrong. Please
gt; gt; help.
gt; gt; Landon
gt;
gt;
gt;