I'm trying to create an excel sheet with 4 columns. Column A will have a dropdown list of choices. Column B will have a dropdown list of either yes or no. Column C will be the weight you need to enter. Column D will show the value after it auto calculate. On a separate tab, there would be different rate (example: minimum charge $500, 100-200 lbs: $400 per lb, 200-300 lbs: $300 per lb, maximum $1000) depending on the value you chose from column A, and whether you choose yes or no in column B.