I am trying to use the Vlookup function in a macro but I can't figure out how to write it. I am using a controlled loop to
cycle through my data. So for the first entry, my lookup data is in cell A2. The lookup table is located in a sheet called
'Trade Table' and the lookup field is in Column B and value needed is in column C. The results go in column G.
The excel formula is as follows:
I have the macro code started, but can't figure out how to finish it (at least I think it is started correctly)
For i = 1 To n
Range("G" & i + 1).Value = Application.WorksheetFunction.VLookup(.Range("A & i + 1"),