Hello,

I'm having troubles with getting the index match function into vba.
And when the row is found get it to be copied to de worksheet.

the formula i want to get into vba is:

PHP Code: 
=INDEX(Database!D$2:D$2000;MATCH($A2&" "&$C2&" "&$G2;Database!$A$2:$A$2000&" "&Database!$C$2:$C$2000&" "&Database!$G$2:$G$2000;0)) 
It compares three different cells which have to match.
this will give me the row i want to copy to the sheet.

Does somebody have an idea to get this done.

many thanks bram