If there are 3 same names in a data and I am doing vlookup, how can I get 1st name on 1st search but when I search it for the second time..the search ignore the first instance.
E g if there are 4 names Raj, Sagar, Raj, Harsh
I want to make sure that if I vlookup Raj then it picks first Raj mentioned on the first position, then ignore the same in 2nd search and gives results as N/A if I search it for the third time as there is no 3rd instance with name Raj.
Any excel function will also help.
