Embeded IF - between ranges

  • Thread starter Thread starter Emily
  • Start date Start date
E

Emily

Using Excel 3. I am trying to assign ABC codes to long list of products
based on % of sales.

A10 is part #, B10 is %. In C10, need formula to pick a code from following
table. The table changes periodically.

Code A=over 80%
Code B=between 60 and 80%
Code C=between 40...60%
Code D = less than 40%
 
The table changes periodically.

Create a 2 column table like this...

0%...D
40%...C
60%...B
80%...A

Assume the table is in the range J2:K5

Then...this formula entered in C10 and copied down:

=LOOKUP(B10,J$2:K$5)
 
Hi,

After arranging the table as mentioned in the previous post, you may also
use this formula

=VLOOKUP(B10,J$2:K$5,2,1)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
 
Back
Top