Name replacement

Copper Contributor



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.



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






1 Reply


Hello Felix,

there is the XLOOKUP() function for something like this. XLOOKUP