Vlookup/Join

excel

#1

Hi All,

I have the following code that I got from one of the topics in this community, the code seems to work fine when there are just 1 row to lookup or join , the code does not pull anything when there are multiple rows, Am I missing something ?

ThanksVlookup.zip (11.4 KB)