Name replacement

Copper Contributor

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

 

 

1 Reply

@FelixMolina0718 

Hello Felix,


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

 

support.microsoft XLOOKUP