Category Archives: VLOOKUP

Two Ways to Compare Columns in Excel

Did you ever squint at two columns of data and examine them row by row to compare the values? Excel can do all that hard work for you in three different ways. Download CompareColumnsinExcel.xlsx to follow along. Note: All values will appear highlighted on the This Equals That Worksheet, initially. Method One: This Equals That…
Read More

Excel Lookup Formula to Create Combined Tables

Lookup functions (VLOOKUP and HLOOKUP) are among the most useful Excel functions to pull data from multiple column-/row-sorted lists into a unified table. Think of it this way, these functions ask a simple question and return the answer. Question: is the data from a specific cell reference in this column or row? Check out our…
Read More

Categories

Monthly Archives