For vlookup, make sure you also read not only the formula, but the specific 'rules' you need to do to also make it work correctly.
http://www.howtoexcelatexcel.com/blo...tion-in-excel/
https://exceljet.net/things-you-shou...-about-vlookup
I've also heard that index match is much better, but have never actually tried it yet.