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

ExcelGangster

New Member
Joined
Mar 22, 2011
Messages
1
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:

  1. Allow inputting of a customer's current inventory by checking boxes next to products the customer already has
  2. 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:

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

Watch MrExcel Video

Forum statistics

Threads
1,108,492
Messages
5,523,260
Members
409,506
Latest member
reneekeane

This Week's Hot Topics

Top