Thanks that helps!
"Richard Buttrey" wrote:
On Mon, 19 Sep 2005 11:19:08 -0700, "Matt Cromer"
wrote:
Is there something that I can type in the "return column" part of the formula
that will make the formula dynamic as I copy it to the right it will return
column 2, then 3 in the next column and 4 in the following column?
Make the return part of the formula
column()
You might need to add in a constant if your data doesn't start in
column A. e.g.
=vlookup("whatever",myrange,column()-1)
HTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
|