• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Range-based value retrieval

Status
Not open for further replies.
cym469

cym469

New Member
upload_2016-10-5_15-25-1.png upload_2016-10-5_15-22-39.png

I need to retrieve the value in column A wherever X falls between B & C. So, the value would be "7/11/2016" because 7/12/16 15:50 falls between 7/11/2016 8:00 and 7/18/2016 7:59.

Can someone please help me?
 

Attachments

  • upload_2016-10-5_15-24-11.png
    upload_2016-10-5_15-24-11.png
    794 bytes · Views: 1
  • upload_2016-10-5_15-24-20.png
    upload_2016-10-5_15-24-20.png
    794 bytes · Views: 1
Status
Not open for further replies.
Back
Top