Thread: How do I return an entire row of data from a reference array?

I have a worksheet of reference information containing rows of data in many
columns that I need to re-use on other worksheets within the same workbook.
If I keep one column of data unique, what function can I use to pull back ALL
the columns of information for each unique row? I know with VLOOKUP I can
pull back one column of data per lookup, but how can I pull back multiple
columns?

I'm using XP Home.

Hi tvmodica

Try this
http://www.rondebruin.nl/copy5.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl



"tvmodica" <tvmodica@discussions.microsoft.com> wrote in message
news:2CB13C61-1184-4DA1-A1DD-5512BCD37E12@microsoft.com...
>I have a worksheet of reference information containing rows of data in many
> columns that I need to re-use on other worksheets within the same
> workbook.
> If I keep one column of data unique, what function can I use to pull back
> ALL
> the columns of information for each unique row? I know with VLOOKUP I can
> pull back one column of data per lookup, but how can I pull back multiple
> columns?
>
> I'm using XP Home.

tvmodica wrote:
> I have a worksheet of reference information containing rows of data in many
> columns that I need to re-use on other worksheets within the same workbook.
> If I keep one column of data unique, what function can I use to pull back ALL
> the columns of information for each unique row? I know with VLOOKUP I can
> pull back one column of data per lookup, but how can I pull back multiple
> columns?
>
> I'm using XP Home.
If you include an array of column numbers as the 3rd argument to the
VLOOKUP function and array enter the formula, it will return the data
from the designated columns of the lookup table.

Alan Beban