Hi, the task for the "Choose practise 3.17" is to write a choose formula to return the Stock for the Stock ID "IN0005". The approach which I favoured is to have a "Choose" function as the main function outside the bracket (and find the row number for the stockID using the Match function) to meet the requirements of writing a Choose function. My final formula reads as follows: =CHOOSE(MATCH("IN0005",D31:D35),C31,C32,C33,C34,C35) where the nested Match return the row number of the stock and the correct Stock is found, in the adjacent column, using this result.
The Answer given in the Practise file is : =VLOOKUP("IN0005",CHOOSE({1,2},D31:D35,C31:C35),2,0) which is in my opinion not what the question had asked for. This is a "Vlookup" and a nested "Choose", not a "Choose" and a nested "something else"
Perhaps I am looking at things to critically but how would one interpret a question like that when doing the MO-211 exam?
Hi Peter,
Great to see you're practicing! First, you wouldn't be presented with a question like that in the MO-211 exam. This is quite an advanced and unconventional use of these functions designed to extend your skills beyond what is standard. The MO-211 exam would not expect you to have this level of knowledge.
Regarding your formula, while it works, it isn't an efficient way to construct a formula like this because you have had to individually select each row in the CHOOSE function's value arguments. If you were looking up values in large tables, this would be inefficient.
That said, it's great that you're thinking creatively about how to write formulas and nest functions. It's exactly what this type of question is designed to encourage. Well done!
Mynda
