Tutorial: Using a named range when doing a vlookup

By | February 4, 2015

Meh. There are a few benefits to using named ranges:

  1. It makes the formula easier to read for others
  2. It means you don’t have to worry as much about absolute references.

But it does require that you are organised, that you use easily understood table names and that you don’t go adding a load of rows below the table.

I prefer to not have tables under each other and use the whole columns to lookup (eg “A:C” as opposed to “$A$1:$C$100”). This does away with having to care about adding or deleting rows down the track and is a bit quicker when putting the formula together too.

Leave a Reply

Your email address will not be published. Required fields are marked *