Macro for Vlookup copy from one column to next one and change column reference

[RajivShrivastav]

Hello all,

I am working as financial analyst with a leading chemical firm in Belgium. I am looking for macro to copy vlookup formula from one column to next one and change the column reference of the vlookup function in this new column. For example if vlookup in the existing formula is getting data from column 7 of the source file. I want to copy this formula to next column and get data from column 8 of the source file.

Please help

Thanks

Rajiv

[teylyn]

Hello Rajiv,

welcome to the forum.

Are you specifically after a VBA solution? If the formula is set up right, you can just copy it across.

=Vlookup(What,LookupRange,column(A7),False)

This one will return the value from the 7th column of LookupRange. Copied one column across, it will return values from the 8th column.

If that does not help, post a sample file.

cheer