Hi, I need to use INDEX/MATCH Array Formula within VBA to lookup a date value that can be between two dates (FROM and TO). The following formula works fine in an Excel spreadsheet but I need to do it within my VBA code.
{=INDEX($C$3:$C$7,MATCH(1,IF($A$3:$A$7 <= E4,IF($B$3:$B$7 >= E4,1)),0))}
Thanks for your help.