Retrieve range of info if another range equals

[roxorvoxor]

I really tried and tried my bestest and Googled the excrement out of this but I just couldn't win. I want to look at column "Resolution" and for every cell marked "Action Register" I want the information in column "Root Cause" to populate on another worksheet in column "Action Item". I've tried using INDEX, VLOOKUP, IF and even made them tables but I can't get the formula right. I'm sure this is easy for many of you. How can I make this right? I would love to post screenshots or a working file but I can't seem to figure that out either? Feel inadequate much Thanks.

 

[roxorvoxor]

So the closest I can get is a single hit. I'm using =INDEX(Table11,MATCH("action register",Table12,0)) and it will give me the first row that has "action register" in it however it won't travel down the line and populate subsequent rows. That is where I am right now.