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

[forts]

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?

[melishan]

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