Hi Guys!

Iīm new in the forum and is my first question. I created a table where based in several competences anyone can evaluate performance and potential. My issue comes when based on that result (colum Y in "Perf&Pot" Sheet) I want to export that to a nine box matrix (Sheet 2 "grid" in the attached excel). As could be several people in the same box I wasnīt able to com up with a formula that solves this.

I didnīt use macros as I’m not an expert!

Anyone that can help me?
Pasta1.xlsx