Though it takes a small period of time to adjust yourself to this way of thinking, tables are great for SEO research applications like keyword research and many more activities. Where “Table1” is our new cell reference, “” is the Column name in which the data we’re looking for is stored, and “Table5” is the table in which we’re looking to find a match and pull through the value from column 5. This is the same query written in a table: You can see cell references “A2”, cell ranges “$A$2:$E$11” and worksheet references “‘KW rank’!”: This is an example of a “pre-table” VLOOKUP. Using a VLOOKUP as an example, let’s take a look at how formulas change the way they refer to cell ranges, other tables and columns. This process introduces bugs and errors quickly.

Why? Because if you add more data, you have to manually adjust each cell reference. We don’t like cell references, especially when they apply to a large array of data. First of all, a formula applies to an entire column immediately, not just in the cells you apply the formula to.Įnter a VLOOKUP formul into a column and the entire column will populate with the caluculation automatically. This animation shows you how to make a Table in Excel: highlight the cell in the top left hand corner, then CTRL=SHIFT with the down key to highlight, then CTRL+L to create table.Īpart from the obvious differences in formatting, tables become quite powerful for two reasons.

How to use excel 365