On Dec 30, 1:13*am, "Ragdyer" wrote:
Try this:

=Index(AT8:AT3000,MATCH(N1255,'[EURUSD_1 hour_Heikin Ashi.xls]1 HOUR ha
ANALYSIS'!$N $8:$N$3000))

--
HTH,

RD

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

"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.- Hide quoted text -

- Show quoted text -

Thanks! That worked great, even better than expected. Sure can learn
lots from these groups.

Regards,

RH