I read the thread on Complicated Vlookup-type problem in a large dataset.

I am facing a similar problem with my research.
I was able to generate grandmaid separate from momid. In other words the grandmaid generated is not a duplicate of momid. However when I generate grandpaid. its the same as grandmaid.
Why does vlookup do that?