Forum Discussion

stephurso's avatar
stephurso
Copper Contributor
Jan 21, 2022
Solved

Auto-populate a cell with the contains from another cell

Hello:   I have a spreadsheet that I would like to auto-populate information to a cell from another cell.    Example.  In B2 I type in 4122 and select Enter.  The text description for item 4122 (...
Formulas and Functions
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Jan 21, 2022

stephurso Create a lookup table as demonstrated in the attached file. Depending on your Excel version you might be able to use XLOOKUP. Otherwise you'll have VLOOKUP or INDEX/MATCH at your disposal.

  • stephurso's avatar
    stephurso
    Copper Contributor
    Jan 21, 2022

    Hello: Riny_van_Eekelen 

     

    This worked great! I used the VLOOKUP formula.  Just one question.  When there is no part number in B2, C2 displays #N/A.  Is there a way to suppress that so it's just blank until someone actually puts in a part number into B2?

    • Riny_van_Eekelen's avatar
      Riny_van_Eekelen
      Platinum Contributor
      Jan 21, 2022

      stephurso Then you can wrap the lot in an IFERROR, like this:

       

      =IFERROR( vlookup-formula , "" )

      • stephurso's avatar
        stephurso
        Copper Contributor
        Jan 21, 2022
        Like this? =IFERROR(VLOOKUP(B2,Parts,2,FALSE)

        I keep getting an error message.

Resources