Hi,

I need an asisstance on the vlookup function. I wish to vlookup from a
column which already consist formulaes. However, vlookup doesn't allow
me to do that unless I paste value them.

Any idea that I can use other formula withour paste value the source
data?

Thank you

Formulas should not pose a problem with your VLOOKUP.

The result of the formula is the value you are looking up.

Show us some typical data and a VLOOKUP formula that won't work unless you paste
specialvalues.


Gord Dibben MS Excel MVP

On 2 Apr 2007 20:33:00 -0700, "Jentan" wrote:

Hi,

I need an asisstance on the vlookup function. I wish to vlookup from a
column which already consist formulaes. However, vlookup doesn't allow
me to do that unless I paste value them.

Any idea that I can use other formula withour paste value the source
data?

Thank you

It doesn't matter if there are formulas. One guess might be if these are
numerical values they are simply not the same
values, maybe a decimal off here and there? Either that or you haven't
described the problem enough

--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)

"Jentan" wrote in message
ups.com...
Hi,

I need an asisstance on the vlookup function. I wish to vlookup from a
column which already consist formulaes. However, vlookup doesn't allow
me to do that unless I paste value them.

Any idea that I can use other formula withour paste value the source
data?

Thank you