Vlookup with Running Countif
This Concept is used for the data where the Lookup values are not unique in Table Array.
To make the Lookup column unique using running countif concept and find out the data when required.
Like in below example, Id is not unique, so a New_Id is created using the running countif concept. Refer to the attached sheet for detailed explanation.