Automatically copy cells from one sheet to another
Trying to use VLookup to automatically copy cell data from one sheet to another. I tried to create a function that searches for "Project Name" and "Comments" columns in a sheet titled "Projects" and copies "Comments" to a sheet titled "Campaigns", where the Project Names are exactly the same in both sheets. Can't quite figure out what is needed to get this to flow correctly to another sheet.
Help Article Resources
Check out the Formula Handbook template!