I did of course, forget the path.<bg


--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------


"Max" wrote in message
...
What can I add to return the cell value from column AT1253,
instead of the row number of the match?

Just bolt on an INDEX part (indexed on col AT) to use the MATCH's return

Untested, but this should work for you:
=index('[EURUSD_1 hour_Heikin Ashi.xls]1 HOUR ha
ANALYSIS'!$AT$8:$AT$3000,MATCH(N1255,'[EURUSD_1 hour_Heikin Ashi.xls]1
HOUR
ha ANALYSIS'!$N$8:$N$3000))

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"rhhince" wrote in message
...
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.