Forum Discussion
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 (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.
Steph
stephurso In te file I sent you the formula would become:
=IFERROR(VLOOKUP(B2,Parts,2,FALSE),"")
See attached.
11 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?
