Forum Discussion
Excel Auto Update
mathetes I tried the formula both within the vlookup and outside and can't get it to return any information. I played around with the hours as well, making it far enough so that if someone was to open it now, it would change, but still nothing.
D26 is where the =today is at
date of 7/29 is cell d28
and i'm trying to return the 'on call' info in the cell nexdt to the 7/30 cell.
And if the suggestions from mtarler for some reason don't work (we often work as a tag team here on the techcommunity boards)....if those don't work for you, might I suggest that instead of an image you upload a sample of your actual workbook after putting names like Luke Skywalker and Mickey Mouse in instead of the real names. And anything else that is proprietary or private info should be changed so as to be anonymous.