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