I have an issue with this goggle sheet formula, if any one can help it will be greatful. I need the names of the Employees from Column C to be shown in Column J whoever is on OFF on that particular day. It is ok even it is formula driven or a Data validation in Column J, already there is a drop down in Column J in cell J9, but am unable to get the names who are on OFF when i select the drop-down for those particular days..
Thanks for your help in advance
Bookmarks