Say I have this formula:

=INDEX(Distances!$A$1:$AE$31,MATCH(AU928,Distances!$A$1:$A$31,0),MATCH(C928,Distances!$A$1:$AE$1,0))

So that returns the correct value from lets say cell k5, after it looks up the respective columns and rows. How do I return the value in the column to the left of cell k5 - in this example j5?

Would it have to do with OFFSET?

Thanks in advance