Excel CHOOSE Function

How to use the Excel CHOOSE function

		Index Value	Result
		1	Alan	=CHOOSE(C4,"Alan","Bob","Carol")
		3	Carol	=CHOOSE(C5,"Alan","Bob","Carol")
		2	Bob	=CHOOSE(C6,"Alan","Bob","Carol")
		3	18%	=CHOOSE(C7,10%,15%,18%)
		1	10%	=CHOOSE(C8,10%,15%,18%)
		2	15%	=CHOOSE(C9,10%,15%,18%)
	What Does It Do?
	This function picks from a list of options based upon an Index value given to by the user.
	Syntax
	=CHOOSE(UserValue, Item1, Item2, Item3 through to Item29)
	Formatting
	No special formatting is required.
	Example
	The following table was used to calculate the medals for athletes taking part in a race.
	The Time for each athlete is entered.
	The =RANK() function calculates the finishing position of each athlete.
	The =CHOOSE() then allocates the correct medal.
	The =IF() has been used to filter out any positions above 3, as this would cause
	the error of #VALUE to appear, due to the fact the =CHOOSE() has only three items in it.
	Name	Time	Position	Medal
	Alan	1:30	2	Silver	=IF(D30<=3,CHOOSE(D30,"Gold","Silver","Bronze"),"unplaced")
	Bob	1:15	4	unplaced	=IF(D31<=3,CHOOSE(D31,"Gold","Silver","Bronze"),"unplaced")
	Carol	2:45	1	Gold	=IF(D32<=3,CHOOSE(D32,"Gold","Silver","Bronze"),"unplaced")
	David	1:05	5	unplaced	=IF(D33<=3,CHOOSE(D33,"Gold","Silver","Bronze"),"unplaced")
	Eric	1:20	3	Bronze	=IF(D34<=3,CHOOSE(D34,"Gold","Silver","Bronze"),"unplaced")
			=RANK(C34,C30:C34)