The $ sign makes the references absolute (will not increment when you drag /
fill the formulas). The only place where you really need to place the $ signs
on a vlookup is in the range of cells that you are looking into since
normally you want that list to remain absolute. Personally when I do a
Vlookup I always make the range of cells that I am looking into into a named
range. By default they are absolute referenced and it makes the formulas a
lot more compact and easy to read.
--
HTH...

Jim Thomlinson


"*Suzannah*" wrote:

Hi :) can someone please tell me why the dollar sign ($) is necessary in the
VLOOKUP function?