In using INDEX and MATCH to perform a multiple-condition VLOOKUP, I'm currently getting results for the desired column using the below formula, but the result is consistently 1 row lower than desired.

```
{=INDEX($A$2:$E$1200,MATCH(1,(A:A=A2)*(E:E="WS01"),0),3)}
```

In the attached image, we see Row 4's S/N returned for row 3's result in finding a "WS01" entry. If I replace the multiplier (*) in MATCH with an addition, I get the correct result for the first store (#2), but then for all following rows, the formula ends up providing row 4's S/N (REG01), so that doesn't seem to be the right path either.