I would like to assign a categry based on certain criteria. The
criteria is set up on a diffrent sheet. I would like to have a
function/formula to compare the data in the criteria and assign the
category. For example i have to assign the categories based on monthly
usage to the parts.

Data:
Part No Usage Category
AAA 50 A1
BBB 30 A2
CCC 25 A3



Criteria:

Usage greater than 30......... A1
Usage greater than 25......... A2
Usage lower than 25......... A3

How i can do this by excel function. Response would be greatly
appreciated