Referencing Cells with a Slider or Pop-Up (Numbers)

In cell A3

=XLOOKUP(E$1,PMZ TETRA 1 PERMUTATIONS::B$2:Y$2,PMZ TETRA 1 PERMUTATIONS::B3:Y3,0)

The copy down until A6.

You see that I put the drop-down menu in cell E1 of the table, which means that you'll have to unmerge the cells of row 1 and only merge the first four ones.

You're welcome.

So you wanted something complicated. Like that? LOL!

=INDIRECT(ADDRESS(ROW(),$E$1+1,4,TRUE,"PMZ TETRA 1 PERMUTATIONS"))

Quite unsafe though as it relies on the fact that both tables always have the same structure (unless you want to rewrite the formula) and that the main table never changes name (because it's hard-coded as a string). XLOOKUP better.

Where would that pop-up menu be located? (in which cells?)

What would be its values?

From that selection, how are the small tables getting their data, in other words, how does it relate to the permutation number?

This picture has to be a montage, you cannot have four tables with the same name on the same sheet.

Do you mean that the pup-ups would replace the 1-2-3-4 at the top of each column in the small tables? Or the 3-7-8-10 in the first column? Or neither? One for each? So you could select 1 to 24 for each one?

Otherwise, it's not clear where, for example, the 10 at the intersection of 8 and 1 in the first small table comes from. That's important because it determines how the number in the pop-up would be used (if you're looking for a formula to populate the small tables).

In other words, explain it that way: the formula in cell W (what address?) will use the number in pop-up cell X (what address?) to look for a number in range Y (what address?) of the big table and return another number from range Z (what address?) of the big table.