text not always in same cell

[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?

 

[Claus Busch]

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.

 

[PeCoNe]

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