Forum Discussion
jessicalive
Jan 03, 2020Copper Contributor
How to create a Product Inventory List with Codes
Hello, I am trying to create an inventory list where if I enter in a code, then the product name automatically appears in the adjacent cell. For example: Code Product Name (I e...
- Jan 03, 2020Yes, it’s possible.
Checkout both VLOOKUP and the INDEX and MATCH functions. The former, VLOOKUP, should suffice.
mathetes
Jan 03, 2020Gold Contributor
Yes, it’s possible.
Checkout both VLOOKUP and the INDEX and MATCH functions. The former, VLOOKUP, should suffice.
Checkout both VLOOKUP and the INDEX and MATCH functions. The former, VLOOKUP, should suffice.
- jessicaliveJan 03, 2020Copper Contributor
Thank you very much, I have done it mathetes