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:
To no avail.