Lookup problem
 

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

Lookup problem
 

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

Pete

Lookup problem
 

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

Lookup problem
 

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

Lookup problem
 

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