You should have posted this as a continuation of the same thread - I
haven't a clue what you are referring to.

To answer your question - yes, there is a function ROW(), which you
can look up in Excel Help to get further details.

Pete

On Dec 11, 12:55 pm, J.Mart wrote:
Sorry wasn't thinking when I wrote that example but you all got what I was
asking. Now is there a similiar function to Column called Row( ) to get the
same desired effect for HLOOKUP?