Learn how to use the formula to lookup information from table in a 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
1/9/2025
Clicking a chapter link below will open the video in a new window. Or Hover over the video timeline to view chapters in this window.
00:00 Learning about Excel Formulas
09:19 Using the Function
17:23 VLOOKUP from Demo 2 to Demo 1 file (Demonstration)
23:55 Pulling in more info
28:40 Reversing VLOOKUP (Demo 1 to 2)
37:50 Reports in SI (EZ Query)
47:00 Function Extras