With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Friday, June 9, 2017
yogi_Mark Names Of Actors That Are Out Based On Form Submittals Of Date Out And Date Back
The problem I'm having is that vlookup is stopping at the first actors name which shows up in the Actors Out form. When there is someone with multiple days out(Example AMY) "OUT" will show up as out when B1 is between 5/30/17 and 6/1/17 but not when B1 is between 6/8/17 and 6/10/17.
Please let me know if there is another to find if the actor will be out based on the cell B1 and the information being entered into the google form.