Hi Jacob,

I'm now getting

compilation error
Method not valid without suitable object



"Jacob Skaria" wrote:

As Joel mentioned it may be inefficient. Since your original query was around
hookup try this one..from VBEimmediate window

?Application.HLookup(Range("A2"),Range("B2:F6"),2)


If this post helps click Yes
---------------
Jacob Skaria


"Kashyap" wrote:

Compilation error

Expected:=