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.