=LOOKUP(N19,{0,11,21,31,41},{"'E'","'D'","'C'","'B'","'A'"}) hapo maana yake Nini nimeweka vigezo vya seli yangu kama imefikia 0-10 maana yake itaonyesha kapata E, aliepata 11-20 itaandika D nk kumbuka kile kigezo kinachotokana na namba ulizopanga kukiwekea hizi sign" "
Nimemaanisha seli ya N19 kama imefikia vigezo inabadilika na kuwa hizo herufi
Au
=Lookup(N19,{0,10000,100000,1000000,10000000,100000000},{"HANA HELA","ANA HELA YA MAJI","HELA ANGALAU YA SUPU","ANAJITAHIDI ANAWEZA ANGALAU KUHONGA","ANAJITAHIDI NA ANAWEZA KUHESHIMIWA MTAANI","KAPAMBANA SANA NA YUKO VIZURI SANA"})