i've tried match/vlookup and other simple formulas which i can find over the net but to no avail. Appreciate if i can get any advice or help from here.
I have an ordered attendance list, i want to be able to type in a random name in a fixed empty cell. It will run through the column with the names and mark a "absent" or "present" in the adjacent cell next to the name if a match is found.
Is this even possible with basic excel?
P.S: New to excel, pardon me if I've broken any rules here. I'm using excel 07 and I do not have background in VBA.