Conditional values when using text and numbers...

[sdemeo]

Hello. I'm trying to create a formula that is a bit above my level. I have a range of cells that use a drop menu. I'd like another cell to return a corresponding value when a selection is made. I want that value to depend on the amount entered in yet another cell.

For instance, if I select a product from a drop menu and enter the dollar amount of the product, I want a commission amount to appear in another cell based on the product and amount.

Can this be done?

[NBVC]

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

[ChemistB]

Yes, best to attach an example spreadsheet showing how your workbook is set up. (Go Advanced>Manage Attachments). Is this commission coming from a table?