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!!

Can you not use something like:

Please Login or Register  to view this content.

Yes Arowbot, that does work and thank you for replying! Thing is I was hoping I could do it using "Select Case" because I have many cases I need to define. I'm having problems understanding how to define "cases" in order to achieve many different If statements.

I don't believe that cases can check 2 different conditions...It checks if one is correct and then if not then checks the next. It won't check one and then if correct check the next...

Ok, thank you. Think I might have to build all the "If's".... then use a case select to call each of the "If's"....as they are needed.