I have a macro I'm trying to create to map a bunch of old values to new values. At one point I need to do a match on 2 columns and get the value from a third column. In normal excel I would run the formula below, but as it is a Formula Array (have to CTRL+SHIFT+ENTER to run) I'm not quite sure how to get this to work in VBA

```
=INDEX($D:$D,MATCH(1,(E2=$A:$A)*(F2=$B:$B),0))

```

Any help appreciated