When you say duplicates to new rows of data, do you mean the look up range of cells? Or the data in your original table? Maybe you want to explain with a sample. By the way, if you want to post a larger file, try using something like box.net or other file sharing sites, and post the link here.