Choose Function Formula

[acool]

Hi Everyone!

I am currently trying to create a choose function formula which toggles between inputs based on the the scenario chosen. In this specific example, I am provided two different data sets--based on the scenario that I chose (1 or 2), I would like my formula to pull the values from that data set. I am attaching an example below for reference. Any help would be greatly appreciated. Thank you!

 

[DanteAmor]

How about:

=CHOOSECOLS(A3:B37,E2)

 

[acool]

How about:

=CHOOSECOLS(A3:B37,E2)

Hi Dante,

Thank you for your help! This formula does work, but I was curious if you knew of a way to tweak the formula so that it allows me to sort my columns from largest to smallest while maintaining the proper values if necessary. As of now, it does not all me to make changes to the array when trying to sort. Appreciate all of your help!

 

[DanteAmor]

to tweak the formula so that it allows me to sort my columns from largest to smallest

Try:

=SORT(CHOOSECOLS(A3:B37,E2), ,-1)

 

[acool]

Try:

=SORT(CHOOSECOLS(A3:B37,E2), ,-1)

Thank You!