Dependent List From Already Created Tables Across Multiple Sheets

Copper Contributor

Hi everyone. I’m working on a database and trying to setup a dependent list of options in a cell depending on the selection from another list of options in the previous cell.

I have created multiple tables across multiple sheets for the data for both lists but can’t seem to figure out how to link them in my main transactional table so that the right list populates in the second cell based on what’s selected in the first cell. Tutorials/info I’ve found want me to create a new table for the XLOOKUP function, but is that necessary if the tables already exist?

Any help would be greatly appreciated!

1 Reply