Originally Posted by chaley
This is an excellent suggestion. You would need as many arms in the switch as the highest series number, at most 10.
As long as you are on a roll, how would you deal with the second level of indexing? Would you use something like
More of the same. But why the lookup? I thought lookup was the same as switch but with fieldnames instead of values?