The formula in your OP *WILL* work *exactly* as you say you want it to.

The reason *you* can't get it to do so, *is* the main question!

Probably, your data values are *not* as you may think they are.

If these values are being imported, there are numerous possibilities for
contamination, so that they are not recognized by XL as they may appear to
the eye.

That's the reason I suggested keying in values yourself, so that you're sure
that *both* the lookup values in the datalist and the cells to be calculated
are exactly the same.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"fryguy" wrote in message
...
Of course I tried it.

The help file specifically states "Lookup_value... Lookup_value can be a
value or a reference. If loo..." So it can't be the result of addition or
a
sum function. It doesn't even work if you make a refernece to a cell with
the sum function, that returns the correct value of 1.1735.

Does anyone else have any other ideas!?


"RagDyer" wrote:

Have you tried it before posting here?

Manually key in some test values, and check it out.

It should work fine!
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"fryguy" wrote in message
...
=vlookup((a1+0.1),$B$1:$C$45,2,FALSE) Can the lookup_value be a
reference
plus an amount? I need to look up a foreign exchange rate when it
reaches
ten points higher. So... 1.0735 is the original exchange rate, and I
need
to lookup the same rate when it reaches 1.1735 and return the date it
reahces
this rate. It would be a two column lookup_array, rate and date.