sverweis function

sverweis function - 消息

#1 已发布: 2021/9/1 14:43:51
Stefan Müller

Stefan Müller

0个赞,共45个帖子。

组: User

Hallo guys,

is there a similar function in smath for sverweis like in Mathcad or Excel?

Searching for a variable in a matrix and give back a certain number in that row?

Thank you br Stefan
#2 已发布: 2021/9/1 15:05:01
Alvaro

Alvaro

1,139个赞,共1,805个帖子。

组: User

Hi. You have findrows in SMath

Clipboard01.jpg

Best regards.
Alvaro.
1位用户喜欢此帖子
Stefan Müller 2021/9/1 15:08:00
#3 已发布: 2021/9/1 15:06:31
Stefan Müller

Stefan Müller

0个赞,共45个帖子。

组: User

o perfect thank you!!!!
#4 已发布: 2021/9/1 15:19:23
overlord

overlord

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

组: Moderator

You can either use findrows() as Razonar mentioned.
Or you can use custom written vlookup() function uploaded before.
But I would stick with findrows() if I had to choose.

Regards

Worksheet1.sm (8.43 KiB)已下载 1243 次。

2021-09-01_21-17.png
#5 已发布: 2021/9/1 16:33:53
Jean Giraud

Jean Giraud

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

组: User

Utilities Matrix FindIndexKey.sm (119.23 KiB)已下载 1234 次。
  • 有新帖
  • 无新帖