text not always in same cell

  • Thread starter Thread starter PeCoNe
  • Start date Start date
P

PeCoNe

column B contains in a unknown row the text "Referentiekoers"
two rows below that is my quote and percentage i need in 1 cell
how can i address that quote and percentage from another sheet?
 
Hi Peter,

Am Wed, 12 Mar 2014 22:21:00 +0100 schrieb PeCoNe:
column B contains in a unknown row the text "Referentiekoers"
two rows below that is my quote and percentage i need in 1 cell
how can i address that quote and percentage from another sheet?

try:
=INDEX(B:B,MATCH("Referentiekoers",B1:B100,0)+2)


Regards
Claus B.
 
Claus Busch schreef op 2014-03-13 07:39:
Hi Peter,

Am Wed, 12 Mar 2014 22:21:00 +0100 schrieb PeCoNe:


try:
=INDEX(B:B,MATCH("Referentiekoers",B1:B100,0)+2)


Regards
Claus B.
Thanks Claus, that solved my problem.

Can you also help me with the question "disclaimer page"?

Bye Peter
 
Back
Top