Thread: drop down list box to select table

Hey everyone,

I'm working on a sheet that will size wires by referencing different tables. There is a 3 wire table and a 4 wire table. The user picks from a drop down menu either 3 or 4 wire and inputs a current. Another cell reads the current and finds the smallest number that is greater than the input current and finds the appropriate wire size. What I am having trouble with is selecting which table to read data from. If 3 wire is selected I want a cell to point to the 3 wire table which another cell can read from and find the appropriate size. Any suggestion would be greatly appreciated. Thanks.