VBA Excel 2010 VLOOKUP VBA Programming Method to Return Data from Table by String

Code:
the_result = Application.WorksheetFunction.VLookup(12019, Worksheets("Sheet1").Range("A:G"), 3, False)
MsgBox the_result

[@3forts]

A very uncluttered, to the point example of vlookup with code I could easily modify and use in my project immediately. Thank you. Thank you. Thank you.

[@riyaziqbal]

What if I don't know the last column? Is there some way I can use the last row to the right instead of editing last column name every time?

[@melishan94]

how can I do a vlookup in vba with 2 search criterias and with using diffrent lookup sheets? Please, I need urgent help!

[@ohcrapitsmrG]

Msg box is good for debug but useless for majority of people uses of Vlookup