Jun 16 2024 08:33 AM
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
Jun 16 2024 09:25 AM
Hello Felix,
there is the XLOOKUP() function for something like this.