I have a 2 Sheets x and y as follows:

```
x
____________________________________________
State | 1 | 2 | 3
ME | | |
VA | | |
y
__________________________________
State | Type | Date
VA | 1 | 2/12/2012
VA | 3 | 1/15/2012
ME | 2 | 8/1/2011
VA | 2 | 2/2/2012
ME | 1 | 1/4/2011
```

I need a formula that can find and match the values in columns A and B of sheet y against B1 and A2 of sheet x and put the value of the corresponding date from sheet y into the correct column on sheet x

The issue is that most excel 2d arrays require unique values in the first lookup column (in this case 'y'!$A:$A) .

Is this possible?

I have tried:

```
=IF(ISNA(INDEX('y'!$C:$C,MATCH(1,($A2='y'!$A:$A)*(B$2='y'!$B:$B),0))),"",INDEX('y'!$C:$C,MATCH(1,($A1='y'!$A:$A)*(B$2='y'!$B:$B),0)))
```

To no avail.