Use of Choose Function with two levels of points

[baidya91]

I want to choose a figure from a table which has two levels of points (row-level and column-level). Now I want to a choose a figure (Here it is 60300) like row level 2 and column level 3. How can I choose it using choose function? The table is as follows:

		Level	Level	Level
		1	2	3
Level		Points	Points	Points
1	Points	35800	50000	70500
2	Points	36900	50700	80770
3	Points	38000	60300	90530

 

[stunnrock]

Hi, you wouldn't use the CHOOSE function for this. You need the INDEX function. e.g.: =INDEX($C$4:$E$6,2,3)

 

[baidya91]

Hi, you wouldn't use the CHOOSE function for this. You need the INDEX function. e.g.: =INDEX($C$4:$E$6,2,3)

Thanks