I have a static database on sheet2 that lists a bunch of recurring jobs TO BE DONE each month (including name, $ amount, type of work, etc). These jobs represent a small portion of the total jobs done each month.
The total Jobs that ACTUALLY GET DONE each month are entered into database on sheet1 (which includes name, $amount, type etc., and other columns as well). I want to have the RECURRING jobs on sheet2 get marked as done when the ACTUAL work is entered onto sheet1.
I've played around with nesting a MATCH function inside an INDEX but I'm not sure I'm on the right track. Any suggestions?
Bookmarks