How do you do it.
This is a function for a cell in Excel that I would like to do the same in VBA

=INDEX('pageone'!$C$3:$C$99999,MATCH('pagetwo'!$A$3&"/"&'pagetwo'!$B$3,'pageone'!$A$3:$A$99999&"/"&'pageone'!$B$3:$B$99999,0))

Notice I am making use of the "/" as a dummy symbol to separate the two values.

Any help would be greatly appreciated. Thanks.