30 Excel Functions in 30 Days: 05 – CHOOSE « Contextures Blog

2Yard: CHOOSE() isn't volatile. There are very few volatile functions and they are listed here: Volatile Excel Functions INDEX has always been the non-volatile alternative for INDIRECT(). The major difference between CHOOSE and the other index-based alter

blog.contextures.com