Use the CHOOSE Function

Having a choice is always a good thing and it's no surprise that Excel would have a CHOOSE function to give you the power to choose. This handy function by itself really doesn't do much, but when you put it in some specific scenarios like offering a list for it to execute against, it actually comes in quite handy. For example it's a good way to figure out what quarter you are in if you have dates to match. Check out the video to see this brief example.

📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!

#excel
#msexcel
#doughexcel

-~-~~-~~~-~~-~-
Please watch: "Convert Table in a PDF File to Excel"
-~-~~-~~~-~~-~-

[ashishtayade]

Thank you sir very nice gide & very nice best choose function information teaching video.👍

[jsvlad]

not sure why this is better than vlookup? it seems like a variation.. nothign to fancy. i would use a helper column so that way if i wanna change Q1, Q2.. ... like if i had 2 clients and one started its calendar year on jan1=Q1 and another started its calendar year on june1=Q1...