Hello,

If I have a matrix that looks something like

A
B 0 0.2 0.4 0.6 1
50% 1 2 3 4
70% 5 6 7 8
100 9 10 11 12


I nedd a funtion that will be able to read the matrix somthing like

=MyMatrix(A,B)


if A between o.4 and 0.2 and B between 50 and 70 then the result is 6
If A between o.4 and 0.6 and B between 50 and 70 then the result is 7

I presume I can do it with a lot of if statements but maybe there is a
cleaner and faster way to do it.


Many thanks
Dan