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



On Mar 21, 2:11 pm, "T. Valko" wrote:
You're welcome. Thanks for the feedback!

Biff

"mithu" wrote in message

ups.com...



Thanks that worked great

On Mar 21, 1:32 pm, "T. Valko" wrote:
Use something like this:

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

Then just drag copy across

Biff

"mithu" wrote in message

groups.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?- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -