vlookup adding data to a field with existing data?
If my spreadsheet has a notes column and notes are in the field. Then I use a form to collect information and notes via another spreadsheet. Once I pull the information from the second spreadsheet over to the first one, will the notes from the second spreadsheet be added to the notes on the first spreadsheet or will they be overwritten? Obviously I use a vlookup formula to match up my companies from the second spreadsheet to the first spreadsheet, so the new information is added according to each company. However, what about adding new notes to an already existing notes field or do I have to provide for two note fields?
Thanks for your assistance.
Help Article Resources
Check out the Formula Handbook template!