€œUse of more then 7 nested if statement€�
 

I used if statement in the form of
=IF(A34=A2,C34,IF(A35=A2,C35,IF(A36=A2,C36,IF(A37= A2,C37,IF(A38=A2,C38,IF(A39=A2,C39,IF(A40=A2,C40,I F(A2="","","Un Known"))))))))
(It means if cell A2 is equal to A34 then print C34 and if cell A2 is equal
to A35 then print C35 and respectively others and if cell A2 is equal to €œ €�
then cell C2 is equal to €œ €� and if these all things are false then print €œUn
Known€� )
(I used this formula in cell C2)
Here I used only 7 nested if statement. But now I want to use more then it
nearly 500 nested if statement.
Please help me and guide me about this problem
Thanks