sverweis function

#1 Posted: 9/1/2021 2:43:51 PM

0 likes in 45 posts.

Group: 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 Posted: 9/1/2021 3:05:01 PM

Alvaro Diaz Falconi

992 likes in 1674 posts.

Group: User

Hi. You have findrows in SMath

Best regards.
Alvaro.

1 users liked this post

Stefan Müller 9/1/2021 3:08:00 PM

#3 Posted: 9/1/2021 3:06:31 PM

Stefan Müller

0 likes in 45 posts.

Group: User

o perfect thank you!!!!

#4 Posted: 9/1/2021 3:19:23 PM

overlord

552 likes in 1332 posts.

Group: 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 KiB) downloaded 24 time(s).

#5 Posted: 9/1/2021 4:33:53 PM

Jean Giraud

983 likes in 6866 posts.

Group: User

Utilities Matrix FindIndexKey.sm (119 KiB) downloaded 37 time(s).

SMath Forum

sverweis function - Messages