Forum Discussion
Can I pull particular data from a list?
Hi everyone! I hope that this is the right place to post this question and apologize if it isn't.
I'm have a listing on inventory items in an Excel doc, each of them has a unique inventory code, as well as inventory for that item at beginning and end of year, there are just over 8000 inventory items. For a report I'm working on,I have been given a list of 900 of the inventory codes for items which I need to list out the ending inventory for.
Is there a way to use those inventory codes to pull the correct data from the master list? Or is do I just need to go hunting?
I'm have a listing on inventory items in an Excel doc, each of them has a unique inventory code, as well as inventory for that item at beginning and end of year, there are just over 8000 inventory items. For a report I'm working on,I have been given a list of 900 of the inventory codes for items which I need to list out the ending inventory for.
Is there a way to use those inventory codes to pull the correct data from the master list? Or is do I just need to go hunting?
1 Reply
Absolutely. Get acquainted with one or more of the following functions. Depending on how your 8000 inventory items are organized you might choose one over the other.
VLOOKUP This is perhaps the easiest IF the unique inventory code is the left most column in your table of data.
INDEX and MATCH can work no matter where the inventory code is in the table.
There are also some new functions that could work well: FILTER in particular.
For more assistance, it would help us help you if you could upload a sample of the data you're working with.
