4e115444-172d-4f1e-87c9-9c76da3e1553 5 4 5 decimal

&[DATE] &[TIME] - &[FILENAME]

I would like to have a function like lookup (vlookup, hlookup) in smath.

data bar size Weight(kg) bar dia(mm) bar Area(mm^2) 4 0.11 4.23 14.05 5 0.173 5.29 21.98 6 0.249 6.35 31.67 7 0.302 7.00 38.48 8 0.389 7.94 49.51 10 0.560 9.53 71.33 13 0.995 12.7 126.7 16 1.56 15.9 198.6 19 2.25 19.1 286.5 22 3.04 22.2 387.1 25 3.98 25.4 506.7 29 5.04 28.6 642.4 32 6.23 31.8 794.2 35 7.51 34.9 956.6 38 8.95 38.1 114041 10.5 41.3 134043 11.4 43.0 145251 15.9 50.8 202757 20.3 57.3 2579204 mat :

bar_size 16 :

bar area

As1 # :

data data 2 data rows range 14 range el :

Locate 1rst exact value in vector V x col FindIdx j 1 : V j col el x ≠ j j 1 + : while j 0 ≡ inexistant j V j col el 12 mat if 31 line :

key 9.53 : col 3 : 12 mat

idxkey data key col FindIdx :

idxkey 6 9.53 12 mat

recover 'row'. data idxkey 11 el row 10 0.56 9.53 71.33 14 mat