Hello,
Hope you are well.
I have the following formula in Sheet1 that matches a name and farm to give an email address:
<code>
"=INDEX(Adresboek!$C$2:$C$500,MATCH($C$8&$C$9,INDEX(Adresboek!$A$2:$A$500&Adresboek!$B$2:$B$500,),0))"
</code>
What I am trying to do is, that when I click on Page3 of...