I don't know if or how to use operators in Match statements (<,>,=)

I need a multi-conditional index match statement with greater than and less than criteria.

Any formula wizards have an example or explanation?