=IF
 

Please help:
I have a table
Basically I just need to return from list E1 When Dates are =D1 and <=F1
so
2/23 Tim
2/26 Tim....
3/2 Tom..
3/9 Mike

A1=(TODAY)
D1 E1 F1
23-Feb TIM 7-Jan
2-Mar TOM 14-Jan
9-Mar MIKE 21-Jan

The formula will be in
A2

=IF
 

If($A$1=Median($A$1,D2,F2),E2,"")

=IF
 

On Saturday, February 24, 2018 at 5:07:48 AM UTC-6, Roger Govier wrote:
If($A$1=Median($A$1,D2,F2),E2,"")



thank you