Hello!
I currently use a simple grid in Excel to manually reference information to generate quotes. The main columns are:
Maximum Size (list of values from 50 to 1900 in increments of 50)
Category A Cost (list of values that relate to the values in Maximum Size Column)
Category B Cost (list of values that relate to the values in Maximum Size Column)
Category C Cost (list of values that relate to the values in Maximum Size Column)
What I am trying to do is set up in another sheet that pulls from the grid sheet with an option to use a dropdown to select the Maximum Size first and then another dropdown for the Category (A,B, or C) and have the appropriate value for the cost appear in the next column.
So if in the grid sheet 200 Max Size and Category A is 14, I would like the 14 to autopopulate after the two dropdowns are utilized.
I hope I'm explaining this clearly. I'm still learning different functions and formulas. Thanks in advance for your help!!!!
Bookmarks