Using MATCH

[rhhince]

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.

 

[Ragdyer]

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 !
---------------------------------------------------------------------------

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.

 

[Max]

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))


---

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.

 

[Ragdyer]

I did of course, forget the path.<bg>


--
Regards,

RD

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

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))


---

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.

 

[rhhince]

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 !
---------------------------------------------------------------------------

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

 

[Max]

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

---

 

[RagDyeR]

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 !
-----------------------------------------------------------------------------------------------

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]

You're right. The OP did good.
He clarified in a private email to me