Thanks, that worked just fine. Tom- to answer your question about the repeat numbers. I had to create a table that has many matching nubers associated with just a few key files in order to use a vlookup function. There was just too many criteria to test to use an if statement. There may be an easier way to do it- but I am new to Excel. The way I have done it accomplishes the task though. Thanks again.