Hi,

I'm having difficulty linking the results of a formula to a cell that contains a drop down menu. In the file attached, you'll notice that I am pulling the data (color preference, # of colors) from the data table onto the player specific data table via an offset function. When I select Player 1, the responses automatically change because of an offset function, and the table is populated with the responses of player 1.

The offset function is:
J14 =offset(C5,$L$10,0)
J15 =OFFSET(D5,$L$10,0)
J16 =OFFSET(E5,$L$10,0)
J17 =OFFSET(F5,$L$10,0)

The match function is:

L10 =MATCH(J10,B6:B8,0)

The problem is, I want to be able to change these very responses on the Player specific data table via a drop down menu in addition to having the offset formula present. column M is an example of what I want (scroll over to see the drop down menus) but I can't figure a proper way to incorporate the offset formula and drop-down menu.

How can I create this link?

Thank you for the help! :)