I am using hlookup to locate a value in a spreadsheet. Here is the function
typed into the cell:

=MATCH(MAX(Sheets(1)!A:A),Sheets(2)!A1:H1000,0)

If I type in the row number instead of the max function then I get the
correct value so what's happening is I am getting the value contained in the
cell (maximum value) of column A rather than the row value.

I think I should possibly use the match function instead but that wont work
either so how do I return the row number containing the maximum value in
column A of my sheet containing the array rather than the actual value
(Address?).

Any help much appreciated.

Kind regards, Mark