match multiple columns to show value

Is it possible to match values in two tables to show specific values? 

In excel you can use =IFNA(ARRAYFORMULA(INDEX(xxxx,MATCH(yyyy&$zzzzz,cccc,0))),"N/A")

As you see in this table there is an order that haves two different SKU's

So I would need to have the logic as follows: if SKU and ORDER_NUMBER matches SKU_2 and ORDER_NUMBER_2 then show Sales Price. If I am just having a relationship between table 1[ORDER_NUMBER] and table 2[ORDER_NUMBER] I will get a total sales price for the whole order, but I need it to see the sales price per sku. 

Table 1:

Table 2: