Issues with barcode scanning

Hi Everyone,

I need help for a non profit organization that I have created the attached workbook for. The workbook attached is to work like this:
- person scans a keytag with a unique barcode in column A of January 2015 sheet with a barcode scanner
- keytag ID populates in column A of sheet and displays corresponding first name and last name
- the members sheet is where members name and assigned key tag ID is assigned

When you scan the key tag, the formula is suppose to check the members tab to see if that key tag ID exists. If it does, display name.

As you can see in January 2015 sheet, there are some scans (highlighted) that do not display name but if you go to members tab, it really does exist.

What can I be doing wrong? I've been working on this for weeks.

Thank you

Thanks Marvin and I appreciate your welcome!

You are correct, I did spot some duplicates so that's easy to take care of (I hope)

However, their seems to be another issue. For instance, BAO003 IDTag has a name associated with it. However when the key tag was scanned in Jan 2015, the name did not populate

Yes, that worked. Thank you so much for your help.

I am going to love this forum :-)