Good afternoon StackOverflow.
I've been asked by my boss to make his life easier with this particular spreadsheet.
What I do: Stock Control
What the spreadsheet needs to do:
The spreadsheet has a master list of base stock codes, next to these codes is the amount of time it takes to make an item. So A2 might have an item, A3:A9 holds the time in minutes.
Another list will be pulled off, of what has been made, this list needs to compare to the Master, and automatically populate the times across the relevant columns.
A big issue... This cannot be helped.... The way the stock codes are put together is the biggest issue. A typical stock code is:
Item + Wood Colour + Fabric Colour
Example: CHE+PO+200300 - Would be a Chelford Chair + Pippy Oak + Ambla Green.
However, there are stock codes such as CHEL, CHELL, which have completely different manufacture times.
The lists can get pretty large as well.
I can also provide a sample master list, and a sample stock code list... Can anyone help?
As I understand the question, you want, when you enter the code the time will populate from Master Sheet, in this case you can use the Vlookup