Auto-populate a cell with the contains from another cell

Occasional Contributor



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 (its a long part description) is in C62 (on the same spreadsheet).  When I type in the 4122 into B2 I want it to display the text from C62.  I will need this for 55 items so if someone types in 4233 into B2 then it will reference that cell for that part description.  Not sure if this is a IF Then or statement. 


Currently users have to manually cut and paste or add the part description in and I want to automatic that as much as I can to avoid human data errors. 


Thank you in advance.


9 Replies

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

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?

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


=IFERROR( vlookup-formula , "" )

Like this? =IFERROR(VLOOKUP(B2,Parts,2,FALSE)

I keep getting an error message.
best response confirmed by Sergei Baklan (MVP)

@stephurso In te file I sent you the formula would become:



See attached.


Worked like a charm. One more item while I have you. Is there a way to force the format of the part description to the cell? in the order section some words are bold and or highlighted in red. When I type in a part number such as 4122 the description shows but the formatting does not. Everything is just lowercase with no bold or words with color. Not a big deal but it would be nice.

@stephurso Unfortunately, not something I can help you with. If possible you probably need VBA to do so.

No worries understood. Regarding this code that you supplied which works wonderful. It is possible to add a function that if the user does not add a valid part number (one that is not in cells B11 through B65 then it would display "Not a valid Part Number"?

Try this:
=IFERROR(VLOOKUP(B2,Parts,2,FALSE),"Not a valid Part Number")
Best of luck