Sponsored Link

There was an error in this gadget

Sponsored Link

Thursday, September 18, 2008

Classification Using Lookup function

Many times I came across MS Excel sheet where people use IF Then to classify grades. IF then is really big and confusing in this kind of scenarios. I would suggest you to use LOOKUP function to

1 The scenario is to classify values into Fail, Second Class, First Class, Distinction and Merit.

2. Refer to formula in the image.

3. This is an easy alternative to IF formula.

Formula : =LOOKUP(A2,{0,35,45,60,75,90,100},{"Fail","Pass Class","Second Class","First Class","Distinction","Merit"})

MS Excel, Lookup Format  

Also, do let me know your comments about this post and subscribe to us to receive latest updates via email

We assure you knowledge, not SPAM!

8 comments:

ashley said...

hey good one sarfaraz... plz do keep up yo posts..

Balu said...

Excellent Sarfaraz, Thanks for sharing this info. Keep updating such type of formulas.

Regards
Balu

Sourojit said...

Hi Sarfara, thanks for the post. You are taking off a big chunk of trouble from us by these posts/ Thanks a tonne once again, keep on posting. wish you all the best
Sourojit

akshay said...

good yaar........
thnx for d post..

plz dost keep up yr post....

akshay said...

Formula : =LOOKUP(A2,{1000,3000,4000,6000,7000,9000,10000},{a2*50%,a2*40%,a3*30%,a2*25%,a2*20%,a2*10%})

when i written this .....

than its not working.......

y plz sol my query...

Sarfaraz Ahmed said...

=LOOKUP(A2,{1000,3000,4000,6000,7000,9000,10000},{a2*50%,a2*40%,a3*30%,a2*25%,a2*20%,a2*10%})
is not correct.
As you cant use formula in resulting vector. You will have to provide string.
I am sure you can precalculate those values and provide in last brace bracket.

shahjee said...

Good Serfaraz, Very good,

My All best wishes with u

Dr Pankaj said...

Good one sir,
Keep going...

Post a Comment