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 column B or if 400 CU THHN is selected, then that weight will populate. I don't want them to have to input the weight manually. I think it would be multiple IF functions nested together but I'm not sure how to make it work.
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!!
