Thread: Find a Date in a Range
View Single Post
 
Old 02-15-2016, 08:37 AM
rspiet rspiet is offline Windows 7 64bit Office 2010 32bit
Novice
  
Join Date: Nov 2014
Posts: 12
rspiet is on a distinguished road
Default
Your formula did not work for me, but I got the following formula to work.

=LOOKUP(2,1/((E2>=$A$2:$A$13)*(E2<=$B$2:$B$13)),$D$2:$D$13)
Reply With Quote