software

Hello,

Can anyone tell me if this custom function could work like this or I must
define anything alse ?:

Function CustomVLookup(valuename)
CustomVLookup = VLookup(valuename, A1:B1, 2, False)
End Function

Thanks

Sure you want A1:B1?

why not try

=if(A1lt;gt;Valuename,na(),B1)

anyway,

Function CustomVLookup(valuename)
CustomVLookup = Evaluate(quot;VLookup(quot; amp; _
Valuename amp; quot;, A1:B1, 2, False)
End Function

Good change this will not recalculate if you change anything in A1:B1
--
Regards,
Tom Ogilvyquot;Martinquot; wrote:

gt; Hello,
gt;
gt; Can anyone tell me if this custom function could work like this or I must
gt; define anything alse ?:
gt;
gt; Function CustomVLookup(valuename)
gt; CustomVLookup = VLookup(valuename, A1:B1, 2, False)
gt; End Function
gt;
gt; Thanks