(Solved) – How to Make Vlookup formula dynamic

  • by

Could you help me with this line of code here please. I would like to make the Vlookup dynamic, where as

SalaryWage is the sheetname where the lookup has to be made, and normally, the table range is R33C1:R764C10. Each time a new row is added, so I would like to include it in the vlookup formula in an efficient way

Range(“F4”).FormulaR1C1 = “=IFERROR(VLOOKUP(RC1,’SalaryWage’!R33C1:R964C10,10),0)”

Leave a Reply

Your email address will not be published. Required fields are marked *