I have 3 different workbooks with a variety of stats imported into them. I'm trying to create one main workbook that merges all of the stats. For example I'm trying to collect Brett Favres stats from 2010 and 2009, the stats from both years are in different workbooks but for this example I threw them into one workbook. I had been messing the the VLOOKUP command but every thing I do produces #REF!. Any suggestions on how to find all the data in one row from another workbook based off of a players name then import that row to a main workbook?