Using Excel 2010
I have numerous sheets with names in column E, with names on some sheets as Last, First, and other sheets as Last First Initial.
Worked all day on trying to get the below formula working but to no avail and then I uses IFERROR and it worked, but I would still like to know what...