text not always in same cell

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

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.
 
P

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top