How to compare two columns in different Excel sheets using Vlookup

You can watch a video tutorial here. Comparing columns in two different Excel sheets is an operation you will frequently need to do when working with datasets. This happens especially when you are consolidating data from multiple sources. Using the VLOOKUP() function in Excel provides a way in which this comparison can be automated. VLOOKUP() … Read more