vlookup for mutiple rows

[mithu]

question for you..

i want to use a vlookup like feature to get data from more than one
row.

so lets say column A has my lookup value.. i need it to find the row
with the value i am searching for and return columns b,c,d,e,f (all
columns are consecutive) and paste those values in columns b,c,d,e,f
in a different worksheet.

i know i can go to each individual cell and do its own vlookup.. but
is there anyway to do it all with one command and not go to each cell
and type out the vlook up function?

 

[T. Valko]

Use something like this:

=VLOOKUP($A1,Sheet2!$A1:$F10,COLUMNS($A:B),0)

Then just drag copy across

Biff

 

[mithu]

Thanks that worked great

Use something like this:

=VLOOKUP($A1,Sheet2!$A1:$F10,COLUMNS($A:B),0)

Then just drag copy across

Biff









- Show quoted text -

 

[T. Valko]

You're welcome. Thanks for the feedback!

Biff

Thanks that worked great

 

[mithu]

hmm its really wierd.. does the absolute cell references have to be in
there
=VLOOKUP($A1,Sheet2!$A1:$F10,COLUMNS($A:B),0)

can be done with out absolute cell references

 

[T. Valko]

The only one that knows for sure is you. I can't see what you're doing! I
can only give my best suggestion based on what you've told us.

If you make the references relative and copy across this is what you'll get:

=VLOOKUP(A1,Sheet2!A1:F10,COLUMNS(A:B),0)
=VLOOKUP(B1,Sheet2!B1:G10,COLUMNS(B:C),0)
=VLOOKUP(C1,Sheet2!C1:H10,COLUMNS(C),0)
etc

Biff

 

[mithu]

Ok i am getting it.
Thanks for you help biff

The only one that knows for sure is you. I can't see what you're doing! I
can only give my best suggestion based on what you've told us.

If you make the references relative and copy across this is what you'll get:

=VLOOKUP(A1,Sheet2!A1:F10,COLUMNS(A:B),0)
=VLOOKUP(B1,Sheet2!B1:G10,COLUMNS(B:C),0)
=VLOOKUP(C1,Sheet2!C1:H10,COLUMNS(C),0)
etc

Biff








- Show quoted text -