Choosing value from table (matrix)

Choosing value from table (matrix) - Choosing value in second row by value of first row - Сообщения

#1 Опубликовано: 02.03.2015 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 Опубликовано: 02.03.2015 05:43:53
Davide Carpi

Davide Carpi

1415 сообщений из 2872 понравились пользователям.

Группа: 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 04.03.2015 04:58:00
#3 Опубликовано: 04.03.2015 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.
  • Новые сообщения Новые сообщения
  • Нет новых сообщений Нет новых сообщений