Building multiple Select Cases

Is there a way to define cases that will look can do the following?

1. look at row K for "Chris" if true
2. look at offset 0 -1 and see if the word "Cars" is true
3. if Chris and Cars is found in cells move to offset 0 -6 and add the word "Complete"


The header of each column can be renamed to something like People, Items, Tasks.


Thanks for your help!!