Choosing value from table (matrix)

Choosing value from table (matrix) - Choosing value in second row by value of first row - 消息

#1 已发布: 2015/3/2 02:55:49
mbdj

mbdj

0个赞,共5个帖子。

组: User

Dear users of smath forum, I want to ask question.

How to choose value from second row of "table" by coincidence value "a" with value of first row of "table".
It should be something like "vlookup" in excel.

See below example what I've done, but it do not work.

Could you please help me to write this correctly.




2015-03-02_111946.png
#2 已发布: 2015/3/2 05:43:53
Davide Carpi

Davide Carpi

1,443个赞,共2,936个帖子。

组: Moderator

I guess you have to handle in a better way the range bounds (and there's no needs of nesting loops). In your example the last iteration fails because you call for the cols(table)+1 column of the matrix.

An example here

If you are looking for interpolation InterpBilinear() may helps
2015-03-02 08_15_26-Choosing value from table (matrix) - Questions - SMath Studio Forum.png
If you like my plugins please consider to support the program buying a license; for personal contributions to me: paypal.me/dcprojects
1位用户喜欢此帖子
mbdj 2015/3/4 04:58:00
#3 已发布: 2015/3/4 05:00:46
mbdj

mbdj

0个赞,共5个帖子。

组: User

Thank you very much, your post is very helpful.

Yes, I look for way to create bilinear interpolation.
  • 有新帖
  • 无新帖