MojoJojo2023
New Member
- Joined
- Aug 7, 2023
- Messages
- 7
- Office Version
- 365
- 2021
- 2019
- Platform
- Windows
Hi all! I am trying to convert this Xlookup function to VBA to improve the speed of my workbook. I am trying to get VBA to insert the product of this formula into every cell from B2 to the last row:
=(XLOOKUP(1,(J5<=Sheet2!$H:$H)*(J5>=Sheet2!$G:$G)*(F5=Sheet2!$E:$E),Sheet2!$L:$L))
Does anyone know how this can be applied with Application.WorksheetFunction.Xlookup?
Thanks!
=(XLOOKUP(1,(J5<=Sheet2!$H:$H)*(J5>=Sheet2!$G:$G)*(F5=Sheet2!$E:$E),Sheet2!$L:$L))
Does anyone know how this can be applied with Application.WorksheetFunction.Xlookup?
Thanks!