> For the complete documentation index, see [llms.txt](https://books-gyansetu.gitbook.io/advanced-excel/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://books-gyansetu.gitbook.io/advanced-excel/vlookup-with-running-countif.md).

# Vlookup with Running Countif

**Vlookup with Running Countif** 

This Concept is used for the data where the Lookup values are not unique in Table Array.

**Objective**

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.

![](https://2721809844-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LR_tHSREe3Wm40fY9NG%2F-LRw5-1iC3lYGEkRx74L%2F-LRw73wzmjaJa_-qM6SE%2Fimage.png?alt=media\&token=4c9f8db4-1f21-46c0-bfc5-f65cb1af37fe)

{% file src="/files/-LRw7jxXxDUice7eiEc\_" %}
Vlookup with Running Countif Formula
{% endfile %}