with VLookup I understand that it will return the first occurrence, i.e.
My VLookup is : =IFERROR(IF(VLOOKUP($A1,ADWRFAIL2!A:B,2,0)="R",K1,J1),K1)
Column A contains ABC123456
Column B Contains R or S or T
Clolumn K contains a date
so, if there are 3 items with ABC123456 but each has a different letter in Col B .....
ABC123456 T 18/04/2015
ABC123456 S 19/04/2015
ABC123456 R 20/04/2015
Is it possible to make the Vlookup return the correct one. 20/04/2015