CHOOSE FUNCTION IN EXCEL
The CHOOSE function in excel is a lookup formula that returns one of your mark out values. It assigns each value you enter an integer based on the order they appear. For instance, if you enter the values “Monday”, “Tuesday”, “Wednesday”, “Thursday” and “Friday” into the function, they receive the integers 1,2,3,4 and 5 respectively.
CHOOSE returns one value based on the function’s integer index value.
The CHOOSE function unlike VLOOKUP is simpler in nature and has many uses, such as rating, grading, assigning quarters to date etc.
HOW TO USE CHOOSE FUNCTION
Insert the CHOOSE function. Type “=CHOOSE(”
Syntax: =CHOOSE(index_num, value1, [value2]….)
Type the Index number (index_num) and the Values (value1, value2 etc) respectively
Index _num: type the value you want the function to return and add comma
Values (value1, value2, value3 etc): type the value you want the function to return. If you want the function to return numbers or letters, place each value in quotes and separate them with commas. For instance if you want your function to return Monday, Tuesday, Wednesday, Thursday, Friday then use “Monday”, “Tuesday”, “Wednesday”, “Thursday” and “Friday.
The excel sheet below gives the representation of Sales from the period of 1/1/2022 – 1/21/2022. Use the CHOOSE formula to determine the exact MONTH the following Sales were carried out: