Forum Discussion
How to check which date range an entered date falls between
Hi, I have the following table below. As shown below, I would like to user to enter the Part Number "P/N" (in B2) and Date Built (in B3) on Sheet 1. Based on this data, I want it to look up and ...
OliverScheurich
Thanks so much for this fix. It works great!
Can you walk me through how this works?
Also, is there a way to modify this formula so that if the Date Built isn't within a date range, or no part number is entered, the Rev field is blank instead of the current #Calc?
Really appreciate the help!
An advantage of the formula that I used involving XLOOKUP is that most combinations of missing or invalid data return "Not available" rather than diverse errors. The formula itself is probably somewhat heavy going for anyone versed in more traditional methods though.
- Thanks Peter. And yes, this formula is heavy going as I am one versed in more traditional methods. : )
