I would appreciate help with a formal.
I need to find (search) the current date within a date range (B8:B378); once today’s date is matched in the date column B, I need the value from an adjacent cell from column F.
In the example (image below), today = B138 and I need the formula to return the number from F138 (i.e., 131).
Thanks for your help.
2019-05-10_13-07-23.png
Assuming column B contains actual dates, you could try:
Please Login or Register to view this content.
If someone helped achieve your solution, consider clicking "* Add Reputation" on their post.
If your question has been answered, mark the thread as [SOLVED] using the Thread Tools menu at the top of the thread.
Melvosh,
Thank you for your help. That's exactly what I needed.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks