Vlookup return multiple columns

[Guest]

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?

 

[Guest]

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

 

[Richard Buttrey]

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
__________________________

 

[Guest]

Thanks that helps!

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
__________________________