Use the column() function
if your first equation is in Column D and you would normally put 2 for the
first return column try
=vlookup(value,range,column()-2,false)

do

"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?