Look for values and show related codes in other range

I want to search the CODE for each value in column D. For this I´ve been able to get the formula in E2, getting the output in column E.

=INDEX($A$1:$A$16,MATCH(D2&"*",$B$1:$B$16,0))

• In column A there are CODEs that have a related CODE. The pair relation for each code is in G1:G4
• The CODE1 could be related with any NUM.
• The CODE2 (those in column H), are related with NUMs beginning with 333391
• Could be several pairs of CODE1/CODE2 that begin with same 3 characters, due to that I've set the relations in range G:H

My goal is (For Excel 2019):

If in matches NUMs, there is a related CODE2 as output, then for those NUMs that are related with CODE1, show as output CODE2 intead of CODE1 as shown in "desired output" in image below. how to do this? I hope make sense. Thanks

This approach checks if the looked-up CODE (from column A) exists in column G and, if so, checks if the VLOOKUP of that CODE, in columns G & H, is equal to the result below, in which case the result below is returned - otherwise the looked-up code from column A is returned: The formula in E2 is

=IF(COUNTIF($G$2:$G$5,INDEX($A$1:$A$16,MATCH(D2&"*",$B$1:$B$16,0))),IF(VLOOKUP(INDEX($A$1:$A$16,MATCH(D2&"*",$B$1:$B$16,0)),$G$2:$H$5,2,FALSE)=E3,E3,INDEX($A$1:$A$16,MATCH(D2&"*",$B$1:$B$16,0))),INDEX($A$1:$A$16,MATCH(D2&"*",$B$1:$B$16,0)))

which is then copied down.

Since the INDEX() function is effectively calculated 4 times for each result, it would be more efficient to employ a helper column, such that the INDEX() result could be calculated just once per row, and merely referenced 4 times.