Forum Discussion
HarrisonNutrition
Apr 20, 2023Copper Contributor
Help connecting names to the corresponding code name
Hello all, I am having troubles with connecting First names to nicknames/code names in excel sheets. I have been tasked with creating an easy to read attendance tracking sheet. There are 4 ...
peiyezhu
Apr 20, 2023Bronze Contributor
am looking for a solution to connect the code name with the participant's First name.
What do you mean connect?
Automate to replace code name with participant's First name in Scan Input sheet?
=vlookup(firstname,code=filling_guide!ContainerName)
?
What do you mean connect?
Automate to replace code name with participant's First name in Scan Input sheet?
=vlookup(firstname,code=filling_guide!ContainerName)
?
peiyezhu
Apr 20, 2023Bronze Contributor
Row A1 has 3 or 2 checked in ?
according to Scan input looks like 3?