Hi All, I am new to VBA coding and need help! This is what i want to achieve using a macro


=vlookup(A1,'http://sharepoint.abc.com/Get Values/[Variable_Get Value]'!E:F,2,FALSE)

'Variable' from the above formula needs to be dyanmically substituted based on a column input

Eg if my column B1 has value 1, lookup should be
=vlookup(A1,'http://sharepoint.abc.com/Get Values/[1_Get Value]'!E:F,2,FALSE)

If column B1 has value 2, lookup should be
=vlookup(A1,'http://sharepoint.abc.com/Get Values/[Variable_Get Value]'!E:F,2,FALSE)

I would like to populate C1 with the output. Thanks!


Can somebody please help me?

The pain points are implementing the vlookup to a closed excel file and varying it dynamically.