Index Match/X-Lookup

[acool]

Hi Everyone,

I am currently trying to create a formula that uses an Index Match/X-Lookup to match values to the corresponding scenario. In this example, I have created a data validation list Cell C16. Depending, on the scenario chose in Cell C16, I would like the values in Cells C18-N18 to update based on the corresponding months. So for example, if scenario 1 is chosen I would like January to be 7.43%, February to be 7.27% etc. The values should line up to the corresponding scenario in Cell C16 as well as the corresponding months. Any help would be greatly appreciated. Thank You!

 

[acool]

Ok, how about

=CHOOSECOLS(FILTER(C3:N11,A3:A11=C16),XMATCH(TEXT(C19:N19,"mmmm"),C1:N1))

This worked! Thank you for your help!

 

[Fluff]

You're welcome & thanks for the feedback.