lookup

lookup - 消息

#1 已发布: 2010/10/19 06:10:58
panzonet

panzonet

0个赞,共2个帖子。

组: User

Hello,
your work is greatly appreciated.
I would like to have a function like lookup (vlookup, hlookup) in mathcad.
This is very useful when you have to find data inside a database (matrix).

thanks again

Marco
#2 已发布: 2010/10/19 07:28:28
Andrey Ivashov

Andrey Ivashov

2,344个赞,共4,057个帖子。

组: Super Administrator

Here is example of vlookup(..) function definition for SMath Studio:


Download: vlookupImpl.sm

Regards.
#3 已发布: 2010/10/19 08:14:58
panzonet

panzonet

0个赞,共2个帖子。

组: User

thanks a lot, it works!

#4 已发布: 2010/10/19 08:54:59
Andrey Ivashov

Andrey Ivashov

2,344个赞,共4,057个帖子。

组: Super Administrator

Another possible implementation:


Download: vlookupImpl2.sm.
2位用户喜欢此帖子
Radovan Omorjan 2010/10/19 09:13:00, ⚜ Kenny Lemens, P.E. ᵂᴵ 2023/3/7 11:35:00
#5 已发布: 2021/9/15 19:15:30
MatFlanagan

MatFlanagan

0个赞,共1个帖子。

组: User

Hello,

I hope that this thread is still active.
I am trying to do the same thing with a horizontal lookup. I tried adjusting the vlookup to work, but I can't seem to get it right.
Could someone possibly post a way they have figured out how to use "hlookup" instead of "vlookup"
#6 已发布: 2021/9/15 19:59:12
overlord

overlord

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

组: Moderator

Wrote

Hello,

I hope that this thread is still active.
I am trying to do the same thing with a horizontal lookup. I tried adjusting the vlookup to work, but I can't seem to get it right.
Could someone possibly post a way they have figured out how to use "hlookup" instead of "vlookup"


Write a new hlookup() function.
Or transpose the matrix in vlookup().
Either way it will search for horizontal.

Regards

2021-09-16_01-57.png
#7 已发布: 2023/10/9 17:26:00
Divyang Soni

Divyang Soni

1个赞,共2个帖子。

组: User

Hello, I am trying to download the files but the link leads me to the main website. Please help.
#8 已发布: 2023/10/9 18:28:26
overlord

overlord

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

组: Moderator

Files should be these ones.
Regards

vlookupImpl.sm (4.16 KiB)已下载 1780 次。
vlookupImpl2.sm (8.86 KiB)已下载 1805 次。
#9 已发布: 2023/10/10 08:42:05
Jean Giraud

Jean Giraud

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

组: User

Wrote

Could someone possibly post a way they have figured out how to use "hlookup" instead of "vlookup"


Vertical matrix is easier to inspect, range select.
Visit Samples next day or two ... gigantic Compendium.
lookup(value,table,col) ... working code.
Part 2 Discrete Systems.
Cheers ... Jean
#10 已发布: 2023/10/10 11:51:10
Jean Giraud

Jean Giraud

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

组: User

Wrote

Visit Samples next day or two ... gigantic Compendium.
lookup(value,table,col) ... working code.
Part 2 Discrete Systems


... just uploaded
#11 已发布: 2023/10/10 22:51:11
Divyang Soni

Divyang Soni

1个赞,共2个帖子。

组: User

Wrote

Files should be these ones.
Regards

vlookupImpl.sm (4.16 KiB)已下载 1780 次。
vlookupImpl2.sm (8.86 KiB)已下载 1805 次。



Thank you!!
1位用户喜欢此帖子
Oscar Campo 2023/10/10 23:18:00
  • 有新帖
  • 无新帖