Quote:
Originally Posted by Coach
That looks pretty good, however, I'm curious as to why Davids T isn't on the roster (Column G), even though the short names match?
|
I put the Verification on the wrong side in the second example... my oops. It's verifying if Column A is in Column D, so if you follow row 5 across you'll see it is. Column G should actually be in Column C.
My assumption is that you're maintaining an overall roster in Column C and you're entering names in Column A to see if they are on the roster. Reference a couple posts above to see the shorter version formatted correctly.