MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question
Hello I have two files: an input file and output file. I want to apply vlookups in 16 columns from the input file into the output file. I have written a code in which i am first copying the input data into the output file and then applying the vlookups. I am facing an issue in making the vlookups dynamic. For example, I want to change the lookup value (rows) and the columns in which the formula is being applied. I tried to make it dynamic using a loop and incrementing the values, but did not have much luck. Any help would be appreciated. Files attached for reference. Input file name: Input File Output file name: FY20Q4_Spend_Sponsorships Sheet in which lookups to be executed: Dynamics Tracker Input sheet where data is being pasted: Data sheet Column references are updated in the first row of the Dynamics Tracker sheet for reference.