Thanks Guys
 

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?

Thanks Guys
 

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?

Thanks Guys
 

Ah yes, I've found your previous post now, and I can see that I was
one of the respondents (poor memory). Yes, you can use ROW in a
similar manner with HLOOKUP.

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?