I have a Google Sheet with a number in column B and another in column C. It is a number range that is produced daily. I am trying to create a search box that a user will type in a specific number they are looking for and I need the search box to look on the sheet to see if that number falls between a number range between those columns. I have a formula that looks like this
=(IFERROR(QUERY(A5:J, "SELECT A, B, C WHERE A>='"&M8&"' AND C<='"&M8&"'",0),"NO MATCHES")). M8 refers to the Search Box, and A5:J is where the data is. The search box resides on Sheet 2. This query doesn't work the way I need it to. Is there a better function or query I could use to find if a user-inputted number falls between a number range in the sheet?
Here is the link to the sheet.....Range List Sheet