Hello,

I have a workbook with two worksheets.
Sheet 2 is a change log that as the name indicates logs all the changes that occur to a JB #.
Sheet 1 is a closed log that logs information about closed JB #'s.
On Sheet 1 there are three columns, B, C, D which track information such as 'was an extension granted', 'was the job ever late/over-due', etc. Currently, I have to manually enter Yes or No for each which requires a lot of time to look through sheet 2 and determine if a job meets any of those criteria.

Sheet 2 has all of this information for each job to determine this, but I'm not sure how to get excel to look for a specific JB # and then only look at the column "What Changed" for that job # to determine if it meets the criteria.

Thanks for any and all help in this, sample workbook is attached.

Sample Workbook.xlsx