lookup fuction

lookup fuction - 消息

#1 已发布: 2023/3/6 05:02:40
soomoon

soomoon

1个赞,共42个帖子。

组: User

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

thank you.

未找到文件。未找到文件。
1位用户喜欢此帖子
João Felipe Seráfico Melo 2023/3/6 10:09:00
#2 已发布: 2023/3/6 05:45:04
João Felipe Seráfico Melo

João Felipe Seráfico Melo

7个赞,共62个帖子。

组: User

findrows function within Special Functions plugin is what you're looking for, soomoon
#3 已发布: 2023/3/6 08:36:22
Jean Giraud

Jean Giraud

983个赞,共6,866个帖子。

组: User

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)已下载 1320 次。
#4 已发布: 2023/3/6 09:14:07
NDTM Amarasekera

NDTM Amarasekera

130个赞,共352个帖子。

组: User

bar size.sm (9.63 KiB)已下载 1329 次。

Findrows.jpg
Look within!... The secret is inside you. Best Regards Eng. NDTM Amarasekera - Sri Lanka
1位用户喜欢此帖子
João Felipe Seráfico Melo 2023/3/6 10:05:00
#5 已发布: 2023/3/6 10:05:04
João Felipe Seráfico Melo

João Felipe Seráfico Melo

7个赞,共62个帖子。

组: User

Jean, your example shows EXACTLY what findrows does.
#6 已发布: 2023/3/6 17:23:05
Jean Giraud

Jean Giraud

983个赞,共6,866个帖子。

组: User

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.
#7 已发布: 2023/3/6 23:46:16
overlord

overlord

600个赞,共1,381个帖子。

组: Moderator

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
#8 已发布: 2023/3/7 12:30:02
NDTM Amarasekera

NDTM Amarasekera

130个赞,共352个帖子。

组: User

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)已下载 1005 次。
Find_Flows-R1.sm (26.11 KiB)已下载 1412 次。
Find_Flows-R1.pdf (234.55 KiB)已下载 982 次。
Look within!... The secret is inside you. Best Regards Eng. NDTM Amarasekera - Sri Lanka
1位用户喜欢此帖子
Mark R Harris 2023/3/8 16:34:00
  • 有新帖
  • 无新帖