Vlookup return multiple columns

M

Matt Cromer

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

bj

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
 
R

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?
Click to expand...

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
__________________________
 
M

Matt Cromer

Thanks that helps!

Richard Buttrey said:
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
__________________________
Click to expand...
 
Top