I always wanted to learn more about =CHOOSE() and I am still struggling
This is one of the formula I am yet to grasp the usage logic for it.
Hi Bosco, hope you are doing well. Could you please explain the usage of CHOOSE() in your above formula ? It would be great help
1] The normal used of VLOOKUP function is :
=VLOOKUP("Jacket",A2:B4,2,0)
=VLOOKUP("Jacket",{10,"Sweater";25,"Jacket";30,"Pants"},2,0)
=#N/A
Which return #N/A because of the wrong columns order
2] The CHOOSE function can reverse the columns order
=CHOOSE({1,2},B2:B4,A2:A4)
>>
={"Sweater",10;"Jacket",25;"Pants",30}
3] The VLOOKUP/CHOOSE combines can produce the correct columns order
=VLOOKUP("Jacket",CHOOSE({1,2},B2:B4,A2:A4),2,0)
>>
=VLOOKUP("Jacket",{10,"Sweater";25,"Jacket";30,"Pants"},2,0)
>>
=25
Regards
Bosco