Solved Handling data from a spreadsheet

[NauticalGent]

my efforts are often superfluous as there are so many knowledgeable members here.

I know how you feel, but every once in a while us superfluous members get our moment!

It is amazing how much quicker batch queries are which is why I use them as much as possible. One of the main reasons I offered my lame contribution is that I could follow this thread in hopes to pick up something useful. As usual, I was not disappointed...

 

[NauticalGent]

When I Googled the Choose() function, it looked a lot like the Switch() function, right down the the "all options are evaluated" caution...

So I did a GDB on the difference and it turns out there are a few:

CHOOSE or SWITCH - Excel University

Learn how to easily choose or switch values in Excel with this step-by-step guide. Simplify your tasks and improve your efficiency.

www.excel-university.com

 

[CJ_London]

choose is a vba function not specifically excel - choose an option starting from 1. Only issue can be if there are gaps in the numbers you want to choose from - which is where Switch can come in