I have 2 spreadsheets open and here is what I am trying to do. Let say Sheet A lists serial numbers (F1:F100) but no store ID. Sheet B has the serial numbers (A1-A300) and store ID (C1:C300) but also much more info I don't need. I want to search for the serial numbers listed in Sheet A on Sheet B and have it return the store ID's in a new column (D1:D100) on Sheet A. Make sense?