I'm stumped....What I and trying to do is set up multple IF situations from
drop down lists. As an example:
=IF(AND(B25="Hockey",D25="English",E25="Standard") ,"123456789","Special")...now
I want to say the IF it different it will be this, but IF it's different
again it will be this...and so on. I have already 48 circumstances. If I
knew VB, I'm sure there is a more realistic way to do this.

Any assistance will be greatly appreciated.