Determine value in the 3rd column of a matrix based on the first and second column values

I have a matrix, say like this:

M = [3 2 10; 4 3 4; 3 1 3; 2 1 12; 2 2 10; 4 1 18; 4 2 12];

Where the order is like this: [job, machine, production_time]

So based on the job and the machine the job should be on, I want to deduce the production time on it.

I can not seem to find anything that can do this for me. Any help is appreciated!

Answer 1

[Dyuman Joshi]

Use ismember -

M = [3 2 10; 4 3 4; 3 1 3; 2 1 12; 2 2 10; 4 1 18; 4 2 12];

job = 3;
machine = 2;

idx = ismember(M(:,1:2), [job machine], 'rows')

idx = 7×1 logical array
   1
   0
   0
   0
   0
   0
   0

out = M(idx, 3)

out = 10

If you are working with non-integral values, ismembertol should be preferred instead.

If job and machine contain multiple values, compare them individually and use those indices to get the corresponding values as per requirement.

[Dyuman Joshi]

Any updates, @Lars Meijer?

[Lars Meijer]

This works exactly as I want it to! Thanks a lot.

[Dyuman Joshi]

Great! Glad to have helped :)