View Full Version : DM Help Random Shop Inventory

2016-09-16, 04:08 PM
Hey guys, so I am going kinda crazy and want to set up a random shop inventory that will change every week. My hope is to create large inventory file in excel that has all the items , and then a "daily inventory list" of like 10 items which will pull from the larger list. The way I currently have all the items assigned a number, but that gets tiresome matching numbers to item names. If anybody has a suggestion for how to get excel to pull the name instead of the number I would love to hear it.

Thanks in advance guys

2016-09-16, 05:19 PM
Use the VLOOKUP function.