If, Then, Else

[mcreary]

I need help in writing a quick and dirty code that will return specific values if certain conditionsIf then else function. I have a hundred conditions. IIF Hierarchy Like "CESS*" Or "CXXA*" Or "CLKAA*" Then Return "line Of Business". If Hierarchy Like......etc

Please help

 

[RuralGuy]

Use a Select Case structure.

 

[KeithG]

Actually you could use the Select case statement instead of IF-Else-End If. Look it up in VBA help for some examples.

 

[pbaldy]

I agree with the Select/Case, though with that many options I'd wonder if a lookup table was feasible.

 

[mcreary]

Thanks Guys