I am scratching my head here as I am trying to create a Schedule based off the expected start date from another tab in my work book. I was trying the Xlookup formula but cannot seem to get it to work. What I want to do is if the expected start date matches the date on the schedule I want to paste the job number Field Sup Copper/Fiber Address and City on the date shown in Schedule. there maybe more than one job starting on the same dayCapture.JPG
Bookmarks