Hello to all and I am a basic neophyte when it comes to Excel (2010) but I am computer proficient. PLEASE help me with this as I use (and help) other forums and find very smart people out there:

I have 2 spread sheets

Sheet #1 I have info on columns a-i (1264 lines) column A has item numbers (6 digits)
Sheet #2 I have info in columns a-i also (14,989 lines) column A also has item numbers (6 digits)

All of the item numbers in column A sheet #1 are contained in sheet #2 but since the numbers on both sheets are not even close to consecutive as many 6 digit numbers are skipped on both, this is where my issue arises. Again the 1264 numbers in sheet #1 are ARE in column A of sheet #2.

How can I line up both column A's matching numbers on the same line number so the merged sheet will now have columns A-R with the item numbers matching. I can end up deleting all the excess information after this function is done. Also there are no formulas in either sheet just raw data. I hope this is not confusing and THANKS in advance!

Please help!!!