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...
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.