not sure why C isn't referenced with a number, obtain good results across
columns, but will add the column number. any ideas bout how to copy to a
variable amount of columns


"Barb Reinhardt" wrote:

In order to ensure that the data is being extracted from the right column,
you need to change this:

"=VLOOKUP(R[" & -(dropper - 1) & "]C
to something like this
"=VLOOKUP(R[" & -(dropper - 1) & "]C1

Make sense?