Build new matrix from look up table

Hello,

I have a column vector A, corresponding to which I need to fill a vector C, the same size as A.

The value of C would be assigned from the "look up" table B-CD.

For the closest matching value of B to each element in A, the corresponding CD will be filled in to C.

So for the example below, for A= 0.35, 0.95, the C should be 200, 400.

How do I assign correct values to C?

%This code does not really work

A=[0.35 0.95];

C = zeros(length(A),1);

B=[0.1 0.4 0.8 1];

CD=[100 200 300 400];

minDiff =0.5;

for ii = 1:length(B)

diff = abs(B(ii) - A);

if(diff < minDiff)

B_index = ii;

minDiff = diff;

C=CD(B_index)

end

end

Answer 1

[Catalytic]

C=CD(  interp1(B,1:numel(B),A,'nearest')  );

[Tapashree Roy]

Thanks! Simple, elegant, works!

[Stephen23]

Simpler and more elegant without indexing:

>> A = [0.35,0.95];
>> B = [0.1,0.4,0.8,1];
>> CD = [100,200,300,400];
>> C = interp1(B,CD,A,'nearest')
C =
  200  400

[Tapashree Roy]

Stephen, better still! Thanks!

[Tapashree Roy]

Hi, Follow up question: Now that C is found, how can I find the corresponding B?

i,e.: for this example, when C = 200 400, BC=B would be BC= 0.4 1.