- Sep 10, 2014
I need help creating a formula that will change based on the part type I input in a cell. If I type "Part ABC" in cell A1 for example I want a formula in B1 that will do a simple calculation by grabbing part weights and color percentages from a table with the row that matches "Part ABC". If I type "Part XYZ" I want to grab the values from row matching "Part XYZ", etc. Thanks.