Notifications
Clear all
Topic starter
I am new to IF or AND statements.
I have a date range of Mondays for each week of the year (7/1/2019, 7/8/2019, 7/15/2019, for the 52 weeks of a year) in row 1 (Green), starting with F1
I have a date in C2 (Blue) (Example:9/8/2019) I want to have Cell D2 (Yellow) find and show the closest date >or = to a date in row 1,
In this case it would display 9/9/2019 in D2 (Yellow)
Posted : 26/09/2019 7:14 am
Hi Wade
Try
=HLOOKUP(C2+6,F1:AJ1,1,TRUE)
Hope this helps.
Sunny
Posted : 26/09/2019 11:22 am
Topic starter
I had to change the C2 to each correct reference cell but then it works great ...Thanks very much
Posted : 26/09/2019 1:16 pm
Glad to know it is working.
Cheers
Sunny
Posted : 26/09/2019 10:07 pm
