I’m attempting to write a macro that will have 6 vlookups in one statement but I’m having an error message.
The below macro works when it’s only two vlookups but I would want to add additional vlookups in the macro below. Can you please assist? Thanks in advance.
The other references I want to look up are below from Sheet2;
Dim LastRow As Long
LastRow =.Cells(.Rows.Count, “A”).End(xlUp).Row
With.Range(“B2:B” & LastRow)