I am getting closer I think. Here is an example:
=MATCH(N1255,'[EURUSD_1 hour_Heikin Ashi.xls]1 HOUR ha ANALYSIS'!$N
$8:$N$3000)
This brings the cell number of the match which in this case is row
1253 from the N column from my other spreadsheet.
What can I add to return the cell value from column AT1253, instead of
the row number of the match?
Column AT is 32 columns away from column N.