Search and VLookUp from Duplicate values

[mark888]

Hi Guys,

Need some help to tweak my formula. I tried doing a Search and Vlookup but unfortunately since my data has duplicates, it does not give me the exact field but only returns the first value of VlookUp. Attached my working file.

Ideally I want it to return 9th August but it gives me 15th August instead. Any help would be much appreciated. :-)


Kind Regards,
MArk.

[Gregb11]

Try this is C2:
=SUMPRODUCT(--('data 1'!A:A=A2),--(LEFT('data 1'!B:B,5)="Final"),'data 1'!D:D)

[mark888]

Hi Gregb11,

Yes that works perfectly. Thanks again for your help sir. :-)

Kind Regards,
MArk.

[Gregb11]

You're welcome. Glad it worked!