@Shan Li
First upload the workbook instead of image for better help from members.
Attached work book with formula for you.
Please see attachment
Regards
Bosco
Siga,Bosco,
In Shan Li example the first row in the first table (Date 2017.05.07 in A2:E2) matches 2 values from Table 2. It could be row G3:K3 rate 2.90 and G9:K9 rate 2.50).
Your formula catches the first value? or the highest value?
And actually it is not clear what Shan Li needs in this example, what if there are more than 1 possible value?
Siga