Hello,
I need a dynamic vlookup code in Column N sheet “Aug”, thelookup is in column B sheet “Aug” and the table is in sheet “Mapping”. I needthe vlookup to pull column 3.
=Vlookup(worksheets(“Aug”).range(B),worksheets(“Mapping”).range(“C:E”),3,False.
This is the formula I need to write in vba.
Kr
Hanz