the problem is the 3rd entry of the vlookup, the return value. i want that
to move if the column is copied. so i was hoping on getting an equation in
colB that i could extend to colC, colD, ... without having to change the
return value every time. thanks for the responses and sorry for not being
specific.

~j