How to display a value in a Google spreadsheet when choosing 2 conditions from a drop-down list?

Question

Google Sheets

The task is as follows: to add a coin transfer fee to the calculator, depending on the selected exchange and coin. If the exchange changes, the coin remains and the commission on this exchange is different, then it changes in the cell. I set up the lists, but I haven’t figured out how to issue a commission and haven’t found it yet. Maybe someone here can tell?

Answer 1

Very simple - use VLOOKUP and a combination key which is obtained by concatenating the lookup cells.