Hi,
I have a very very long if/then statement that I want to shorten but not sure how to. I need to choose from a long drop down list then based on that and a type need to pull the correct weight and $ from table. However, if the body & side = 76, then I want to pull the info from A31-A40 other than that all the info should be pulled from A5-A29.
Please see the spreadsheet and current formulas that work, however they are not very clean.
Thank you,
PS
Bookmarks