I am attempting to create a form that will contain two selection options. Then, depending on the combination of selections, a specific dollar value is returned in a separate cell.
For example, the user will choose from ComboBox1 either A, B, or C. Then they will choose from ComboBox2 either 1, 2, or 3. The result is determined by the combination of the options selected. However, there are duplicates involved and I continue to run into road blocks.
I have a sample spreadsheet that would help to explain much easier but I'm not sure how to attach to this post.
I know how to do things like create ComboBoxes and I have an understanding of formulas. I do not write VBA code, but I have used it in the past (mostly researching, finding what works, copying and pasting!).
Thank you for your time!
For example, the user will choose from ComboBox1 either A, B, or C. Then they will choose from ComboBox2 either 1, 2, or 3. The result is determined by the combination of the options selected. However, there are duplicates involved and I continue to run into road blocks.
I have a sample spreadsheet that would help to explain much easier but I'm not sure how to attach to this post.
I know how to do things like create ComboBoxes and I have an understanding of formulas. I do not write VBA code, but I have used it in the past (mostly researching, finding what works, copying and pasting!).
Thank you for your time!
