Macro to apply Vlookup to table of variable rows

[callao2908]

Good evening, annoying your attention, because I need a macro to apply VLOOKUP.
The data to look for are in column G, and the table I'm going to look for are in the range A1: D101.
I look for the Code of column G in the table, and I have to search the data of the other three columns and put them in columns H, I, J respectively. The problem is that both table and column G are variables in rows
Thanks for the attention, greetings Jorge from Peru

 

[PCosta87]

Hi @callao2908

I really don't think you need a macro for that... you could just lookup the values in the entire columns (A:D) or even better, since you are already using a table, just use it instead of referencing a specific range and it will automatically expand range of lookup whenever you add rows to it.

Same thing for the table with the vlookup formula, use a table and then just add the new code below and it will automatically fill the formula for you.

Please see attached

 

[callao2908]

PCosta thank you very much until another opportunity
Closed topic
Jorge from Peru

 

[PCosta87]

PCosta thank you very much until another opportunity
Closed topic
Jorge from Peru

You are welcome