Hi,
I am trying to get the below formula to choose the last instance of the value in the column, The formula I am currently using is shown below, Can anyone help me modify this? I think I need to use sumproduct in some way but cant work it out.

=INDEX('X08'!$L$2:$L$4935,MATCH('Pre-Call'!$H4118&'Pre-Call'!$A4118,INDEX('X08'!$G$2:$G$4935&'X08'!$A$2:$A$4935,0),0))