Select cells from column B and copy to file by comparing with values in column A

Question

Hi there,

I am looking for a way to merge x number of csv files into one and copying the cells from column B by comparing with the values of column A. Is it possible with Kutools as I can't find this function?

https://www.linkpicture.com/q/Vlookup.jpg

Any advice and suggestions will be greatly appreciated. /media/kunena/emoticons/smile.png

Thanks,
Alex