Elseif statement with large table

I have a 4 x 197 table. The first two columns are characters (ID and name), the last two are integers (min and max).

Each ID and name are not unique but a combination of the two is unique within the table. I need to check the table according to the pair "ID & name" and assign a min and max to it, i.e. write it to a new CSV file. Instead of having 197 elseif statements, how can I make an efficient script to accomplish this?

See attached image. Any help is greatly appreciated.

[Luna]

Do you have a rule for assigning the max and min number?

[James]

Yes - the min and max are specified on the same row. So if I needed the min and max for:

ID = 'L22' and name = 'JP',

the script should return:

min = 90, max = 450

Answer 1

[darova]

Will it work?

for i = 1:197
    i1 = find(newID(i)==ID & newname(i)==name);
    newmin(i) = min(i1);
    newmax(i) = max(i1);
end