I have tried a number of different formulas and data validation scenarios but I have not been able to get my second drop down to recognize the choice in the first drop down. I have a chart of sizes (including fractions) and several weights for each size. I want the weights in dropdown 2 to be only those that apply to the size in drop down 1. Getting the size in drop down 1 was easy. How do I get the 2nd drop down to correspond to the size selected? I have these numbers on a hidden tab within the same workbook.
July 18, 2013 7:20 PM
July 18, 2013 7:47 PM