Lookup with Rule

Hello, i want to ask about a lookup with rule or something like that

for example i have a data from two table like this

Table 1 (Assume this data collected from difference source)

| Bank                      | ID    |
| Elemento Bank             | 91238 |
| EB                        | 37172 |
| Elemento Bank Corporation | 10234 |
| Ele Bank                  | 03941 |
| EBC                       | 28481 |

And then i have table 2 like this

| General Bank Name         | General ID |
| Elemento Bank Corporation | EB01       |
| Hungary Bank              | HB01       |
| Bank of Amazing           | BA01       |

i want to lookup/assign all the value from table 1 which is a various name that people input about the Elemento Bank and i want to assign it to the table 2 which is a general Elemento Bank Corporation so its easier for the company to get all information about Elemento Bank… so its like many to one relation… so the output table should be like this

| Bank                      | General Bank Name         | ID    | General ID |
| Elemento Bank             | Elemento Bank Corporation | 91238 | EB01       |
| EB                        | Elemento Bank Corporation | 37172 | EB01       |
| Elemento Bank Corporation | Elemento Bank Corporation | 10234 | EB01       |
| Ele Bank                  | Elemento Bank Corporation | 03941 | EB01       |
| EBC                       | Elemento Bank Corporation | 28481 | EB01       |

Thank You