You should be aware that vlookup and merge do not function the same way. Vlookup will only return the first instance of a match while merge will return all possible matches. This is typically observed as an increase in overall rows of your data set.
I’d recommend you try to learn some basic SQL function to better understand this. It will help you understand the limits of vlookup.