Naming Table columns

Naming Table columns
12 September 2013

I was reading Contextures post about duplicate entries. In it, she creates a named range that refers to a Table column. That named range will expand and contract as the Table does. Tables have their own built-in names and they are so handy that I find myself using Tables whenever possible.

One of my favorite uses of Table references is using them in VLOOKUP. The third argument to VLOOKUP is the column from which to pull. I've never been a fan of making that dynamic. Instead, I would hard code the number and change it if the columns change. But with Table references, I find myself making that argument dynamic. It's a little less error prone, a lot more self-documenting, and while it's more typing, I don't have to count columns.