Forum Discussion
Solved
Excel IF THEN formula help!
I created a drop down box in column A where they can pick the wire size, but I want the column B to populate automatically: if the wire size 14 CU THHN is selected, then the weight will populate into...
I would create a lookup table with all sizes and weights. The Size column will feed the dropdown and you can then use one of several lookup functions to return the matching Weight. In the picture below, the green cells contain the dropdown, and I've used XLOOKUP to return the weight from the relevant column in the lookup table called Table1.
I would create a lookup table with all sizes and weights. The Size column will feed the dropdown and you can then use one of several lookup functions to return the matching Weight. In the picture below, the green cells contain the dropdown, and I've used XLOOKUP to return the weight from the relevant column in the lookup table called Table1.
THANK YOU!!