Vlookup Problem

[busboy10]

Hi All,

I am dealing with a vlookup issue that i just can't figure out. I
have a vlookup statement that works fine, something to the extent of
vlookup(1.001, A1:C10, 9) for example. However, when i change 1.001
to a cell reference say C30 where C30 = 1.001, it doesn't work!!!!

i can't for the life of me figure out why not. the help says
referencing a cell for the lookup value should work fine.

Any thoughts?!?

 

[busboy10]

I should also note that in cell C30 is calculated like =C29 + .001
where C29 is 1. It doesn't like this for some reason.

if i put in C29 just 1.001 then it works.

 

[Domenic]

Maybe the value in C30 is being recognized as text. Make sure that cell
is formatted as 'General' or similar format (except text), and then
re-enter the number 1.001 in C30.

Hope this helps!

http://www.xl-central.com

 

[Domenic]

Does C29 contain a formula? If so, can you post the formula you're
using?

 

[busboy10]

Does C29 contain a formula?  If so, can you post the formula you're
using?

I am wondering if it is a precision issue since these are decimals. I
have made sure that everything is listed as a number. C29 is just a
static value of 1.

 

[Ashish Mathur]

Hi,

If your range is only A1:C10, then how can the column index be 9? The
column index should be any number upto 3
--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com