MATLAB: Two arrays mapping value

array mappingMATLAB

Hi, I have two arrays A=[1 0.1452; 2.1 0.2487; 3.2 0.3478; 4.8 0.41123] and B=[0.4 0.5 2.5 3.5 1.7]. I wanna get the mapping value of B from A. The rule is to find the ceil value of B in first column of A and return value in second column of A.For example, the ceil value of 1.7 in first column of A is 2.1, so the mapping value is 0.2487. Finally, the mapping value of B is [0.1452 0.1452 0.3478 0.41123 0.2487]. The size of B is over 10000. Please tell me the faster and more efficient method to solve it. Thanks

Best Answer

A((A(:,1) == min(A(A(:,1) > B(1)))),2)
Related Question