How to find 2 values record in table?

Copper Contributor

I'm creating Google Sheet for work, and have problem with advanced formula.

I have one table:

Country 1:  Postal code 1:  Country 2:  Postal code 2:
AT          2341            BE          BE4523
DE          D34215          DE          D34215
BE          BE4523          AT          2341

I have to merge Country 1 and Country 2 with only 2 digits (f.e. DE34 not DED34) and find this linked in such value table:

        AT23    DE34    BE45
   AT23 -       0,15    0,13
   DE34 0,15    -       0,20
   BE45 0,13    0,20    -

For example, in the first record, I have to find AT23 + BE45, and fill a cell with value 0,13.

Is it any solution for that?

1 Reply

@Piotr_Magdziak 

That's better to ask on Google Sheet forums. Excel solution, if any, most probably won't for Google Sheets and the opposite. Compatibility is mainly for relatively simple basic formulas.