Use the Choose Function in Excel to Quickly Return a Value from a List - YouTube
The Choose Function is one of Excel's "hidden treasures." In my experience, most people are unaware of it. Once they discover how useful it is, they "rave" about it. Rather than struggle with "nested IF() statements," you may be able to use the Choose fun...