How do I use an absolute address I've gotten to look the value of said address in a different sheet?

[Pettel]

Hi all,
I would realy appreciate some guidance on a problem that's got me stumped.
I have two sheets in a workbook, one containing response to a stimulus and the other containing the time this response was recorded. I'm interested in finding the time stamp for the maximal response recorded.
So I've used this formula to find the address of the maximum value =CELL("address",INDEX(E4:I4,MATCH(MAX(E4:I4),E4:I4,0))) .
since the data is arranged exactly same in both sheets I figure that all i need to do is retrieve the value from the same address in the "Time" sheet.
Any suggestions on how I should go about it?

Thanks in Advance ?‍?‍

 

[Fluff]

Maybe
=MAX(E4:I4)

 

[Pettel]

That will give the maximal time stamp not the time stamp of the maximal response.

 

[ChrisFoster]

Sounds like a vlookup would work.

 

[Pettel]

Vlookup uses a value,not address,no?
If I use Vlookup wouldn't it will look for the address as a value?

 

[Fluff]

Missed it was on separate sheets.
Try
=INDIRECT("Time!"&CELL("address",INDEX(E4:I4,MATCH(MAX(E4:I4),E4:I4,0))))

 

[Pettel]

Missed it was on separate sheets.
Try
=INDIRECT("Time!"&CELL("address",INDEX(E4:I4,MATCH(MAX(E4:I4),E4:I4,0))))

Thanks!! That worked! ? ?‍

 

[ChrisFoster]

Vlookup uses a value,not address,no?
If I use Vlookup wouldn't it will look for the address as a value?

Apologies, I misunderstood the original query.

 

[Fluff]

Glad we could help & thanks for the feedback

 

[mikerickson]

Perhaps = INDEX(Time!E4:I4, MATCH(MAX(Sheet1!E4:I4),Sheet1!E4:I4,0), 1)