Use CHOOSE to calculate fiscal quarters and as a VLOOKUP alternative

- [Instructor] Excel's Choose function has a number…of different applications, and although sometimes…it might be unwieldy or a bit longer, sometimes it does…provide additional documentation.…On this worksheet here we've got some data entries…in column A and we're trying to calculate…the Fiscal Year Quarter for each of these.…And to this organization, based on the list we see…to the right, the Fiscal Quarter matches up…with the chronological quarter, so first quarter,…January, February, March, second quarter,…April, May, June, and so on.…And here's the formula is cell B2.…

If you're a mathematician, or if you're pretty adept…with using Excel functions you might…write the formula this way.…And there's certainly nothing wrong with it,…and most of all, of course, it does get the answers correct.…By the way, the month function, if you've never…seen it before, simply will extract the month…from a date entry, and so, this answer right here…can only be the numbers one through 12.…So in the case here, it's 10, and what do we do here?…