Cross Table Calculations

^{Hi 87Happy ,}

^{According to your description, the problem is to filter Table 2 through Table 1, and then query the rate according to the origin of Table 1 and the destination filtered out by Table 2, and highlight the minimum rate.}

^{But none of your three tables have primary keys, which makes it difficult to filter the data, and I don't get the data you described, the rate from origin 1 to destination 1 is not equal to 30.}

^{If my understanding is wrong, I hope to be able to point it out.}

^{Best Regards,}

^{Gallen Luo}

^{If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.}