Dynamic statistics

Hi all,

Please find attached 'pseudo-sheet'.

Essentially I have a table of data with many columns. Elsewhere I have an xlookup to bring over specific columns using a dropdown list.

I want to DYNAMICALLY run a T-test on the gathered data from the dropdown results.

i.e. in the attached sheet,
-If I select '1' in K5, it pulls up data below from column B <---happy with this
-If I select '2' in L5, it pulls up data below from column C <---happy with this

Using the Analysis ToolPak add-in, I can then create a t-test table from the resultant data now in K5:K23 and L5:L23 ...however when I update the data in those cells (using the dropdown) the t-test does not dynamically update

Can this be done?

Thanks in advance