Please help with a formula

I believe you are not getting responses because of a lack of information. In your screenshot, where is the formula? What is it showing with your current attempt, and what would you expect it to show? (note that in your screen shot, rows and columns are not even visible, so it will be hard to reference that image in terms of cell D8 should be showing XXX. You may want to provide a different attachment for additional context.