Vlookup

J

Jentan

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
 
G

Gord Dibben

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
special>values.


Gord Dibben MS Excel MVP
 
P

Peo Sjoblom

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)
 
Top