Lookup between two dates

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!

Hi,

Assuming this question still needs an answer and the cell you want the formula placed is the active cell; try this:

Please Login or Register  to view this content.