Hi,
Newbie here ... Can anyone assist with what I am sure is a simple formula.
I would like to look up the value in A2 (459172) from E2:E13 and once found (E3) return "Yes" or "No" if the date in B2 (24/07/2021) is within the range shown in columns F and G. In this instance it would show "No".
Thanks in advance for your help.
Acct_Lookup_Date.JPG
Bookmarks