Vlookup the Same Value Multiple Times in Excel

[@plaenog]

Although this cannot used to search a single "John" and gives you all the result, this is a good and simple way to search a few duplicated values.

[@mohdnasser1157]

Sir, thank yous so much for this video that saved my hell lot of time

[@sureshbabubabu9235]

Thank u so much exactly iam waiting for this video

[@Syedhussainipage]

I am so happy to hear that. I hope you found it useful. 👍

[@sureshbabubabu9235]

Watched so many videos I tried different formulas
This worked for me thank u ❤

[@sureshbabubabu9235]

Sir
But when trying in large data, comparing two same names it reads bottom one came first rather than first

[@asifquader8447]

Sir can i do it with index+match function?

[@Syedhussainipage]

I will get this done in a few days using these functions and will drop a comment here to keep you posted.