It works for me. for min: =MIN(IF(($A$1:$A$50=D1),($B$1:$B$50))) for max: =MAX(IF(($A$1:$A$50=D1),($B$1:$B$50))) Note, that it is an array formulas, so you need to press CTRL+SHIFT+ENTER
I am also new to the topic, but I hope it helps what I’ve found out so far. Your image (the LUT) is a representation of a 3D array, imagine a 64x64x64 cube. This representation is in 2D, one plane is a 64×64 square. You need 64 piece of this plane, which is why the … Read more
You should remove the braces: { and } around single values. struct TECH lut_model_1[2] = {{296.001465, 74.216972, 2.025908, 1.516384, 1, {0.001746, 0.000256, 0.006216, 0.005249, -0.001668, -0.001377, 0.009865, 0.010454, -0.000288, -0.005853, 0.010584, 0.015440, 0.000465, -0.000602, 0.004330, 0.005700, 0.017120, 0.233015, 0.034154, 0.244022, 0.007644, 0.385683, 0.042960, 0.406633, -0.007811, 0.346931, 0.040123, 0.387361, 0.007030, 0.225309, 0.017897, 0.241024, 0.003700, 0.103601, 0.060748, … Read more
for f(x,y) you can use f(x,y)->(a,b) 2D LUT (Look Up Table) But the stored grid points must be selected so dense so that there is max one bump per grid rectangle, otherwise interpolation would not work correctly. If you want to use linear interpolation then the local min/max must be points inside LUT, for polynomial … Read more
You can just use image to index into lut if lut is 1D. Here’s a starter on indexing in NumPy: http://www.scipy.org/Tentative_NumPy_Tutorial#head-864862d3f2bb4c32f04260fac61eb4ef34788c4c In [54]: lut = np.arange(10) * 10 In [55]: img = np.random.randint(0,9,size=(3,3)) In [56]: lut Out[56]: array([ 0, 10, 20, 30, 40, 50, 60, 70, 80, 90]) In [57]: img Out[57]: array([[2, 2, 4], … Read more
Here’s a solution that works on each column successively using lapply(): as.data.frame(lapply(example,function(col) lookup$letter[match(col,lookup$number)])); ## a b c ## 1 A E A ## 2 B D D ## 3 C C C ## 4 D B B ## 5 E A E Alternatively, if you don’t mind switching over to a matrix, you can achieve … Read more
You are looking for a Lookup with multiple criteria. A quick search gives several useful links, listed below. I have marked with * those that I have answered. I have filtered out some of the links that actually deal with other issues. As seen in the links, there are several options to achieve your goal. … Read more