I am trying to copy a LOOKUP formula down in my column to always look at the
same set range of cells for the correct value, but when I drag my formula
down it the formula shifts the range of cells it is looking at for the
correct value. There must be an easier way than re-doing the formula in each
cell. Please help!