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: 

 

CodeProduct Name
(I enter in:) ABC123(Name to appear automatically:) Apples

 

I have approximately 60 codes.  Is this possible?  

 

Many thanks in advance.  

excel
Formulas and Functions
office 365
  • mathetes's avatar
    mathetes
    Jan 03, 2020
    Yes, it’s possible.

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

2 Replies

  • mathetes's avatar
    mathetes
    Gold Contributor
    Jan 03, 2020
    Yes, it’s possible.

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

Resources