Here's my problem. I have a range that will move down to include all the records with the same value in column 2, however, when I try to lookup a value in this range after the first range has changed, I get an error. I don't know if it helps, but for j=1 c1=2 and c2=143, for j=2, c1=144 and...