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

thank you.

File non trovato.File non trovato.

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) scaricato 1309 volta(e).

bar size.sm (9,63 KiB) scaricato 1324 volta(e).

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) scaricato 999 volta(e).
Find_Flows-R1.sm (26,11 KiB) scaricato 1407 volta(e).
Find_Flows-R1.pdf (234,55 KiB) scaricato 965 volta(e).