If the data were in g17 to j21

I would set up a row with
=g17
next to
=max(h17:j17)
and next to it
=INDEX($H$17:$J$17,0,MATCH(MAX(H18:J18),H18:J18,0) )
copy these down as far as you need

" wrote:

hi,

Have a question, the function of Hlookup.

Below are the details in the sheet.

DataSheet
date - Feb1,2005 Feb2,2005 Feb3, 2005
item id
1 100 200 100
2 150 100 250
3 490 500 900
4 90 10 20


Output
item Max Date
1 200 Feb2, 2005
2 250 Feb3, 2005
3 900 Feb3, 2005
4 90 Feb1, 2005

How do I get the above output from DataSheet.
Require urgent help.

Captain