Forum Discussion

jessicalive's avatar
jessicalive
Copper Contributor
Jan 03, 2020
Solved

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...
  • mathetes's avatar
    Jan 03, 2020
    Yes, it’s possible.

    Checkout both VLOOKUP and the INDEX and MATCH functions. The former, VLOOKUP, should suffice.

Resources