loop macros until reach blank in adjacent column
 

I have two columns, A & B. Column A contains data, column B contains a
(VLOOKUP) formulae referencing column A. I want the VLOOKUP formulae to loop
down column B until it reaches a blank in column A.

loop macros until reach blank in adjacent column
 

A formula will not loop anywhere. It just returns a value in the cell in
which it resides. What do you want to do? HTH Otto
"McKCollins" wrote in message
...
I have two columns, A & B. Column A contains data, column B contains a
(VLOOKUP) formulae referencing column A. I want the VLOOKUP formulae to
loop
down column B until it reaches a blank in column A.