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

thank you.

Archivo no encontrado.Archivo no encontrado.

findrows function within Special Functions plugin is what you're looking for, soomoon

Wrote

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

Find Index Key Code is lot more powerful.
Assume your Customer wants more information from his bar diameter
you can give all pertaining informations ...
Add price column, material, delivery ... etc.
Cheers ... Jean

bar size Findndex KeyCode.sm (10,33 KiB) descargado 1301 vez(es).

bar size.sm (9,63 KiB) descargado 1319 vez(es).

Jean, your example shows EXACTLY what findrows does.

Wrote

Jean, your example shows EXACTLY what findrows does

Yes for that simple application.
FindIdx(V,x,col) gives me more for advanced Engineering works
Thanks for the observation.

https://en.smath.com/forum/yaf_postst673_lookup.aspx
Check thread above. You may find it useful.

You can look forum for your questions by searching too.
Searching may result with a ready answer to a question.

Regards

findrows() function revisited.

As a part of a project undertaken to study flows of some perennial streams in Sri Lanka,
a particular stream, located far away from Colombo, was selected and a Rating Table (RT) was
prepared relating water levels to flows. This process took a few years so that the
data would almost cover reasonable range of depths for practical reasons, excluding severe floods.

During this period, an electronic device was also constructed to measure water levels (WL) and
transmit as digital signals to control station in Colombo.
However, the numerical values of transmitted WL had more than 6 decimals,
whereas the Rating Table (RT) was calibrated only to 2 decimals. Hence, initially WL values
had to be refined to 2 decimals for use with RT values.
Earlier a vlookup function which was posted in the forum was used, but it took a long time to process

But when the findrows function was available, data processing was dramatically fast.
Both Excel and SM files must be in the same folder.

Cheers

1.July WL&RT.xlsx (29,52 KiB) descargado 998 vez(es).
Find_Flows-R1.sm (26,11 KiB) descargado 1403 vez(es).
Find_Flows-R1.pdf (234,55 KiB) descargado 959 vez(es).