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

T

Tripp Knightly

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...
 
B

Bob Phillips

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)
 
Top