Excel VBA - Vlookup in a loop

What is the best way to use the vlookup worksheet function in a loop. For each row in a sheet I want to look up a particular value which is stored in second sheet, return the desired value to the designated target cell, them move down to the next row etc.

I have tried the following but get errors in the code:

intNumRowCount = Sheets("Transactions").Range("A4").CurrentRegion.Rows.Count

'counts number of rows in sheet "Transactions" from cell A4

For intRowCount = 1 To intNumRowCount


Sheets("Transactions").Cells(intRowCount, 16).Value = _
Application.WorksheetFunction.VLookup(Sheets("Transactions").Range("A4").Cells(intRowCount, 6), Sheets("Data").Range("A4:F432"), 6)

intRowCount = intRowCount + 1

Where sheets "Transactions" column 16 is where I want to place the result, based on looking up the value in "Transactions" column 6 in sheets "Data".