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.
Bookmarks