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

If the criteria is set up on a different sheet, then you could use a
VLOOKUP formula, but for what you describe you could use this in C2:

=IF(B230,"A1",IF(B225,"A2","A3"))

and then copy down as required.

Hope this helps.

Pete

On Aug 28, 11:47 pm, wrote:
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