How do I simplify the below string to use in Excel 2003. It works in Excel
2007. Is there an easier way to get the same result? Perhaps vlookup and how
would I set it up?
I appreciate any help.
Signed,
Rookie Excel dude

=IF(AND(($C$15)<=270,($C$14)<=20),"vct4482b",IF(AN D(($C$15)<=270,($C$14)<=30),"vct4493b",IF(AND(($C$ 15)<=330,($C$14)<=20),"vct4466b",IF(AND(($C$15)<=3 30,($C$14)<=30),"vct4478b",IF(AND(($C$15)=330,($C$ 14)<=40),"vct4476b",IF(AND(($C$15)<=400,($C$14)<=4 0),"vct4477b",IF(AND(($C$15)<=400,($C$14)<=50),"vc t4473b",IF(AND(($C$15)<=450,($C$14)<=60),"vct4467b ",IF(AND(($C$15)<=450,($C$14)<=70),"vct4479b",IF(A ND(($C$15)<=550,($C$14)<=80),"vct4471b",IF(AND(($C $15)<=550,($C$14)<=90),"vct4469b",IF(AND(($C$15)<= 570,($C$14)<=100),"vct4468b",IF(AND(($C$15)=630,($ C$14)<=110),"vct4484b",IF(AND(($C$15)=750,($C$14)< =120),"vct4472b",IF(AND(($C$15)<=750,($C$14)<=130) ,"vct4470b","NA")))))))))))))))