title: How do I use data from one spreadsheet to fill in similar fields in another spreadsheet?
body: <p>Every month I have to generate a roster of several hundred employees, which includes contact information, duty station, rank, etc. My task is to fill in any blank cells with the relevant details, which I can either find from last month's spreadsheet or the internet database. The rosters don't vary much from month to month. How can I populate the new roster with information from the old roster? For example, if I have A1: <code>John Smith</code>, B1: <code>(123)-456-789</code> in last month's roster and A1: <code>John Smith</code>, B1: <code>n/a</code> in this month's roster, is there a way to automatically find John Smith's number in last month's spreadsheet and have it appear in this month's spreadsheet?</p>