I have a workbook which has multiple worksheets and wanted to apply a vlookup formula through VBA. The reference table is on sheet "categ lookup" range A1:C357. The columns are located on worksheet labeled "Original" and need vlookup for columns R and S and the reference data is in column T, all three columns data start on row 4 since headers start on row 3.
regular vlookup code with out VBA would be the following:
=VLOOKUP(T4,'categ lookup'!A1:C357,2,0)
=VLOOKUP(T4,'categ lookup'!A1:C357,3,0)
I need the formula to apply to last row in each column. Data changes, so need last row formula.
Please help, can't seem to figure this one out.
regular vlookup code with out VBA would be the following:
=VLOOKUP(T4,'categ lookup'!A1:C357,2,0)
=VLOOKUP(T4,'categ lookup'!A1:C357,3,0)
I need the formula to apply to last row in each column. Data changes, so need last row formula.
Please help, can't seem to figure this one out.