Hello, I work in a hi-tech industry that makes hundreds of products. Can someone offer guidance in creating a tool in Excel 2003 that would: Allow inputting of a customer's current inventory by checking boxes next to products the customer already has Display suggested additional products based on a combination of pre-defined priority and what products are in the customers current inventory as defined in step 1 above? Any help or ideas for formulas would be greatly appreciated!

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Auto-populating suggested products based on pre-defined priority and current customer inventory

Hello,

I work in a hi-tech industry that makes hundreds of products. Can someone offer guidance in creating a tool in Excel 2003 that would:

Allow inputting of a customer's current inventory by checking boxes next to products the customer already has
Display suggested additional products based on a combination of pre-defined priority and what products are in the customers current inventory as defined in step 1 above?

Any help or ideas for formulas would be greatly appreciated!

Last edited: Mar 22, 2011