Categories
Create Learn Work

How to use the VLOOKUP function to link 2 Google Sheets

Ever need to look up data in one Google sheet and use that to populate a different Google sheet?  It’s pretty easy to do, but you need to use the VLOOKUP function and the IMPORTRANGE function and it takes 2 steps:

Categories
Create Learn Work

Two Excel Tutorials

I’ve been meaning to get a couple Excel tutorials up here since I’ve been getting so many questions about how to manipulate and analyze data in Excel.  Here are two videos that review using filters and pivot tables in Excel 2010.