vlookup for mutiple rows

  • Thread starter Thread starter mithu
  • Start date Start date
M

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?
 
Use something like this:

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

Then just drag copy across

Biff
 
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
 
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:D),0)
etc

Biff
 
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:D),0)
etc

Biff








- Show quoted text -
Click to expand...
 
Back
Top