Learn how to use the formula to lookup information from a table in one spreadsheet to populate on another. The vLookup can be a time saving formula to input data. Whether using Excel or Google Sheets this formula will work for you.
Demo file 1 Demo file 2 Presentation
Video on how to to VLOOKUP between two Google Sheets: https://www.youtube.com/watch?v=UU7wBC1mh0w