vlookup in macro for multiple columns

Hi,

I have a table with about 20 columns with vlookup(all table contains about 40 columns) that take data from also another sheet (other columns are row data). Example :

=VLOOKUP($CE2,'gl'!$A$2:$Y$21,COLUMN(S1),FALSE)

Could you please assist me to write these vlookups in macro.



Thanks in advance

Originally Posted by haperah

Hi,

I have a table with about 20 columns with vlookup(all table contains about 40 columns) that take data from also another sheet (other columns are row data). Example :

=VLOOKUP($CE2,'gl'!$A$2:$Y$21,COLUMN(S1),FALSE)

Could you please assist me to write these vlookups in macro.



Thanks in advance

Please explain it better, with context, images, anything you can provide, that's too vague to visualize

Hi,

Thank you for your reply.
There are two sheets .
In sheet "g" there is a table with data.(please find attached)
In sheet "sheet with vlookup" there is another data .There is 1 common table in both sheets.
I do vlookup in sheet "sheet with vlookup" in order to pull data from sheet g.
Finally I have in sheet "sheet with vlookup" row data in addition I have about 20 columns with vlookup sample.PNG
My goal is to make the vlookup process in macro.

I hope it's more clear now.

BR`