Good morning,
I posted this question on another board yesterday, but haven't received any answers yet, so thought I'd try here.

I have used the search function and Vlookup seems to be the recommendation but I'm having trouble figuring out the format.

I have a list of serial numbers on Sheet1, the only column on that sheet.

I need that Sheet1 to compare to sheet Log and show me which entries do not have a match. The serial numbers on Log are in column E. Ultimately, the numbers should all be on each page.

I'm including a snapshot of Log. I want the formula to see the number in Sheet1, A3, compare that to Log, column E, and show me any that do not appear in both sheets.

Wow, I should change my User ID to wordy!
Thank you for your help!!

S0# Customer Model Serial # RA # Shipped back to vendor
1582950 West Point TV C19iDVDHB TL0809C19W0022 226 08/17/10
1585173 G H Miller C20HDHB TL0809C200355 228 08/17/10
1529793 J&j Appliance C20HDHB TL20T080777080723A0033 230 08/17/10
1533467 McDaniel Firestone C20HDHB TL202080777080723A03063 244 08/17/10
1550665 Robertson Furn C20HDHB TL20T080777080723-A058 231 08/17/10
1578301 Baldwyn Refrig C23HDHB TL23T080776080723B0072 232 08/17/10
1581745 Smith Furn C23HDHB TL20T080478080508D0252 227 08/17/10

MrExcelHTML isn't working with this message/site, so I hope the above helps to show you what I'm using.