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 ...
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. : )