Match with Muliple Criteria VBA Syntax Issue

I'm struggling to convert this worksheet formula into Vba code.

=INDEX(A2:A15,MATCH(1,("X"=D2:D10)*("Y"=C2:C10),0))

The Vba error sound has beaten my eardrums and i need backup

Thanks

Ah Ok Ill try this,

Thanks

The problem im having is that X and Y are variables and as i am unfamiliar with arrayformula's in vba im
having more syntax issues

dim i as string, j as string

i = "X"
j = "Y"

Selection.FormulaArray = _
"=INDEX(A2:A15,MATCH(1,(j=D2:D10)*(i=C2:C10),0))"

How can i get the above working

Thanks,

Ooh i think i worked it out

i need to break up the quotes with the & symbol and bring in the variables that way.

Think i'm sorted