Try this formula in G24, copied down:

=INDEX($19:$19,MATCH(F24,$3:$3,0))

when you put this formula in I24 for the IPS group, change the $19:$19 to correspond to the respective row number in the main table, i.e. $20:$20 and so on for the other groups...