Seeking and matching values from two tables

Hi experts.

I have two tables on one sheet. Each one has a columns with А numbers (А26175, А36412 и т.д). Another columns have A number relevant numbers.
In G column I need a formula which will seek and match appropriate numbers.
I suppose Vlookup function won't work, because it find only the first match, ignoring the rest ones.

Sample attached.
Will appreciate any help.

Please try at G2 and copy down

=IFERROR(INDEX(C:C,AGGREGATE(15,6,ROW($B$2:$B$148)/($B$2:$B$148=E2),COUNTIF(E$2:E2,E2))),"")

Great. It works! Thank you so much!