Prev: changing the number of rows the mouse scrolls through
Next: Why does following step not working for excel?
From: DS on 24 May 2010 10:07
I have been using VLookup in Excel 2003 for some time but I would like to
expand the VLookup results. Instead of just copying one cell to paste as the
result of the formula, can I have VLookup copy and paste a series of cells
from same row of the found item?

Thanks and have a great day!!! :)
From: Luke M on 24 May 2010 10:11
You can change the result of the VLOOKUP function by changing the 3rd
arguement in the function, which determines which column from the table to
return.
=VLOOKUP(Find_this,In_this_table,#_of_column_to_return,Closest_Match?)

If you want to copy and paste this and have it adapt/change, use a reference
like:
COLUMN(A3)
as you copy this horizontally, it will change in value

--
Best Regards,

Luke M
"DS" <DS(a)discussions.microsoft.com> wrote in message
news:43953484-9A23-4FF1-8D4D-606B656D5E3B(a)microsoft.com...
>I have been using VLookup in Excel 2003 for some time but I would like to
> expand the VLookup results. Instead of just copying one cell to paste as
> the
> result of the formula, can I have VLookup copy and paste a series of cells
> from same row of the found item?
>
> Thanks and have a great day!!! :)


From: Jacob Skaria on 24 May 2010 10:38
The below if copied in Sheet1 cell B1 will return the lookup result from Col
B of Sheet2. and if this formula is copied/dragged to the right it will
return the subsequent columns....

=VLOOKUP(A1,Sheet2!$A:$J,COLUMN(),FALSE)

--
Jacob (MVP - Excel)


"DS" wrote:

> I have been using VLookup in Excel 2003 for some time but I would like to
> expand the VLookup results. Instead of just copying one cell to paste as the
> result of the formula, can I have VLookup copy and paste a series of cells
> from same row of the found item?
>
> Thanks and have a great day!!! :)
From: L. Howard Kittle on 24 May 2010 16:26
Say you want to return five values to the right of the lookup value in the
table_array.

Select five cells where you want the answer and while selected enter this
formula, adjusted for lookup value cell and your table_array range.

Use Ctrl + Shift + Enter to commit. If you need to make changes to the
formula you will have to select all five cells again, make the change and
Array-Enter again.

=VLOOKUP(M1,F1:K3,{2,3,4,5,6},0)

HTH
Regards,
Howard

"DS" <DS(a)discussions.microsoft.com> wrote in message
news:43953484-9A23-4FF1-8D4D-606B656D5E3B(a)microsoft.com...
>I have been using VLookup in Excel 2003 for some time but I would like to
> expand the VLookup results. Instead of just copying one cell to paste as
> the
> result of the formula, can I have VLookup copy and paste a series of cells
> from same row of the found item?
>
> Thanks and have a great day!!! :)


 | 
Pages: 1
Prev: changing the number of rows the mouse scrolls through
Next: Why does following step not working for excel?