Getting cell value based on another cell or formulae

Hi,
I am having a big mental block at the moment.
I am trying to get a excel cell value (i.e. a date) based on a value in another cell
I have a spreadsheet which tracks electricity usage and solar production at my house. I store in column A the Date, Col B the time, Col E the electricity Reading, Col J the solar produced
I can get the last value entered using the formula: =LOOKUP(2,1/('Electricity-Solar-2021'!E1:E1000<>""),'Electricity-Solar-2021'!E1:E1000) (this works)
I can get the reference cell to that value using: =ADDRESS(MATCH(AH22,'Electricity-Solar-2021'!E1:E1000,0),COLUMN(A23)) (this works) - AH22 is the location of the value returned.
I tried using the indirect formula: =INDIRECT(ADDRESS(MATCH(AH22,'Electricity-Solar-2021'!E1:E1000,0),COLUMN(A23))) but I get a value of 0

Essentially I want to get the date that relates to the last entered value.

Any help or example would be appreciated.
Cheers
Tonez

No workbook??
=index(A1:A1000,match(9E303,'Electricity-Solar-2021'!E1:E1000))

no workbook!