Dear Ozgrid Members,
My file contains staff names in AB. I prepared this formula to look up staff names in column C.
When found, then it will look at next 6 cells (C8 to K8); if any number is found (in any of those 6 cells), this will be displayed as "Done" in Column AD, or if not found any number value, then it will be "undone".
It does not give me the desired result. What's wrong with it?
Any help would be great. Thanks in advance.