Hi tvmodica

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

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



"tvmodica" wrote in message
...
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.