Google sheet - between two number


(Meysam) #1

Hi
I am trying to make a bot for my site that get a price from user (his/her budget) and show products that are in special category and are greater (or maybe less than) inputted price.

Can you please tell me how can I select greater or less prices from my google sheet?

Best regards;


(daniel.beckett) #2

Hi @mooghermez

Unfortunately Google Sheets doesn’t have a search option for values being greater or less than a value. When searching for a row it needs to be an exact match for what you’re looking for.