Lookup problem

[Landon C]

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

 

[Pete_UK]

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

Pete

 

[L. Howard Kittle]

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]

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 D...[todays_rates.xls]todays_rates'!$C$774:$C$793)

 

[Landon C]

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