Hello Excel Experts,

I have a question for you! Since you all are experts, I believe you guys are familiar with the CHOOSE function.

=CHOOSE(Index_Num, Value1, [Value2],...)

Normally, I would use CHOOSE function as the following i.e. =choose($A$1, "US", "Canada", "Europe"), where when the value of $A$1 = 1, it'll be US, 2, be Canada etc.

What I'm trying to accomplish here is SIMILAR to the following formula WITH THE EXCEPTION of listing all of the country.

Therefore, ASSUMING if I have all the country's name across row 1, is there a way to make the Value1, [Value2], [Value3] etc to be "automatic" referencing to the rows?

i.e. =choose($A$1, row($1:$1)), where IF the traditional way of doing would be =choose($A$1, "US", "Canada", "Europe", "Australia", "Japan", "Korea") assuming if there's only 6 countries listed in row 1 in column B, C, D, E, F, G respectively for US, Canada, Europe, Australia, Japan and Korea.