Any ways to do something similar to Access Switch() function...

In Excel, instead of doing a bunch of nested ifs for conditional
logic, are there any ways to do it w/ something more elegant like the
Switch() function in Access?

thx...

In VBA there is Select Case.

In Worksheet Functions you can CHOOSE a value from a list, use various
LOOKUP formulae, or MATCH and INDEX.

What are you trying to do?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Tripp Knightly" wrote in message
om...
In Excel, instead of doing a bunch of nested ifs for conditional
logic, are there any ways to do it w/ something more elegant like the
Switch() function in Access?

thx...