Copy specific columns from one sheet to another based on a value that equals on both sheets
I have been looking for a solution and have found some really great ideas/advice, but unfortunately, none that are actually the same as mine.
At the moment, working with (2) sheets (eventually maybe 3) that have a column identified as an "Item #". This item number will be created within SHEET-A. SHEET-B also has a column called "Item #" and has pre set values that match the actual number or the item. SHEET-B has several columns that has data contained within each which provide information about that item.
When an item is created within SHEET-A, it places the item # entered by the end user and IF this "Item #" matches the same "Item #" value within SHEET-B, then I wish to have specific columns from SHEET-B to be copied into columns within SHEET-A.
I do hope this makes sense. After a few hours now of researching for the proper process of doing this, I just had to finally give up and reach out to the professionals. If this has already been answered, please help a newcomer find the proper URL to complete this. ☺️
Help Article Resources
Check out the Formula Handbook template!