Hi friends¡ first post here i would like to know if its possible to do multiple vlook ups with this code (it doesnt work )

Sub Matriz_costos()

Dim i As Integer

For i = 6 To 8

Worksheets("Input").Cells(i, 8).Value = WorksheetFunction.VLookup(Cells(i, 7), Range("G1:H4"), 2, [0])

Next i

End Sub

So in the cell H6 i want to look up the cell G6 in G1:H4 second column
Then in the H7 i want to look up the cell G7 in G1:H4 second column
Then in the H8 i want to look up the cell G8 in G1:H4 second column

Furthermore i would want to search for a concatenated formula that contains the G6 and other information but in the same iterative way.

Thanks for helping me.