Nanogirl21
Active Member
- Joined
- Nov 19, 2013
- Messages
- 330
- Office Version
- 365
- Platform
- Windows
How can I search similar to vlookup to return the matching date that is nearest to today? The search term will have multiple matches, but I only want to return the nearest date. A future or current date is always preferred, but if not available the nearest past date is acceptable.
Example:
Search: Apple
Today Date: 2/8/2022
Expected Result: 4/2/2022
Thank you.
Example:
Apple | 1/5/2022 |
Grape | 7/7/2022 |
Apple | 4/2/2022 |
Pear | 5/2/2022 |
Apple | 1/11/2022 |
Apple | 5/2/5000 |
Search: Apple
Today Date: 2/8/2022
Expected Result: 4/2/2022
Thank you.