Use something like this:

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

Then just drag copy across

Biff

"mithu" wrote in message
oups.com...
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?