none
VBA to use vlookup in a workbook RRS feed

  • Question

  • Hi VBA experts,

    I needed some help, I am currently working on a workbook.

    So, this workbook contains 25 sheets and each sheet contains 11 columns.

    The 11th column currently has this vlookup  "=VLOOKUP(J2,'sheet 24'!J:J, 1, FALSE)"

    Each sheet uses data from the previous sheet. Is there a way to convert this vlookup function into a macro using VBA?

    Thank you very much for your help!!

    Wednesday, January 29, 2014 7:27 PM

All replies