How to vlookup table array with wildcard?

Hi,

Could anyone please help if it is possible to create vlookup with wildcards in table array? or how to create formula to lookup values in attached sample case?

I need to transform extracted system account codes with related attributes into another system account format code. Column A are sample values of extracted codes and Column E are sample of transforming condition (The required attribute used for vlookup is the account code and the 2nd country name).

Sample Case.png