Hello,
I need help how to 'convert' these line of code into the VBA?

LOOKUP(2;1/((J20>=Sheet2!$B$2:$B$25)*(J20<=Sheet2!$C$2:$C$25));Sheet2!$F$2:$F$24)

Thanks in advance!