Name replacement

Hello,

At work I am supposed to scan my associates’s badges in order to keep track of them, as do it I get their ID number paste into a excel spreadsheet. I would like to know if there is a way of replacing their ID number with their name or nickname while scanning, in other words, as I scan their badge I get their name instead of their ID number.

Note:

I have a data base with their ID numbers and corresponding names/aliases.

Thanks,

FM