Need index formula help!

Hello,

I have a spreadsheet that keeps track of a number of managers. I have a separate sheet titled 'gaps' that is going to list all stores without an RGM or any store that is a total of 3 managers short of their target. From my research I think I need an index formula to get this done but I am not having luck with coming up with the formula myself.

Any help is appreciated.

Thank you.