Compare shapes for obtaining a value

Hello,

I received a request to find a way to compare shapes from a table with the shapes from the legend an so to obtain a value and write that in the cell under the shape.
The shapes from the legend have predefine names like „Group 1”, „Group 2”. Her is a sample file. I’m not sure if this is possible.
In the past I did for this case the reverse one. I read the value from the cell and pasted the appropriate shape from the legend over it deleting the contents of the cell.
Dose anybody know a way to do this?

Thank you
Mihai