Using MATCH
 

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.

Using MATCH
 

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.

Using MATCH
 

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.

Using MATCH
 

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.

Using MATCH
 

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

Using MATCH
 

I did of course, forget the path.<bg
Admittedly a bit puzzling to me, but it does seem from OP's reply that
he wants to extract from col AT in the same sheet as the lookup <g
It was fortunate that you gave the other version, RD
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Using MATCH
 

I sort of think that (s)he was smart enough to pick up on the omission and
insert it, and just responded to the first suggestion, considering the OP
went so far as to post the column count between fields.
--

Regards,

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





"Max" wrote in message
...
I did of course, forget the path.<bg
Admittedly a bit puzzling to me, but it does seem from OP's reply that
he wants to extract from col AT in the same sheet as the lookup <g
It was fortunate that you gave the other version, RD
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Using MATCH
 

You're right. The OP did good.
He clarified in a private email to me
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"RagDyeR" wrote in message
...
I sort of think that (s)he was smart enough to pick up on the omission and
insert it, and just responded to the first suggestion, considering the OP
went so far as to post the column count between fields.
--

Regards,

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