using a vlookup function in a Macro

[maacmaac]

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:

Please Login or Register  to view this content.

I have the macro code started, but can't figure out how to finish it (at least I think it is started correctly)

Please Login or Register  to view this content.

[rylo]

Hi

try this

Please Login or Register  to view this content.

rylo

[maacmaac]

Thanks. That works.