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

T

tvmodica

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.
 
A

Alan Beban

tvmodica said:
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.
Click to expand...
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
 
Top