Sub Test

With ACtivesheet
B25 = .Range("B25").Value
D25 = .Range("D25").Value
E25 = .Range("E25").Value
If B25="Hockey" And D25="English" And E25="Standard" Then
.Range ("F25").Value = "123456789"
ElseIf B25="Soccer" And D25="English" And E25="Standard" Then
.Range ("F25").Value = "abcd"
ElseIf B25="Soccer" And D25="French" And E25="Standard" Then
.Range ("F25").Value = "xyz"
'etc...
End If
End With

End Sub

as an example

--

HTH

RP
(remove nothere from the email address if mailing direct)


"K.W.Martens" wrote in message
...
Thanks for the info, but, how can I do it in VBA.....your comment "this
can
be done easily" intriqued me. Any suggestions would be appreciated.
Another
question....I don't really know if I am looking at a "nesting" situation.
Each circumstance within the cell is determined by the drop down lists.
So,
as an example, instead of "Hockey" in B25, it was "Soccer" it would give a
different result. It seems to me that I have an IF/OR situation.....but,
I
still haven't found an answer.



"Fredrik Wahlgren" wrote:


"K.W.Martens" wrote in message
...
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.

It seems as if you want to do nested IF's. Unfortunately, you can't have
more than 7 If statements in a cell. This can be done easily in VBA. See
the
links below. For more links google Excel nested if

http://www.cpearson.com/excel/nested.htm
http://spreadsheets.about.com/cs/exc...tediffunct.htm

/ Fredrik