1页(11条)
lookup - 消息
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
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
Here is example of vlookup(..) function definition for SMath Studio:

Download: vlookupImpl.sm
Regards.
Download: vlookupImpl.sm
Regards.
2位用户喜欢此帖子
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"
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"
WroteHello,
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

Hello, I am trying to download the files but the link leads me to the main website. Please help.
Files should be these ones.
Regards
vlookupImpl.sm (4.16 KiB)已下载 1780 次。
vlookupImpl2.sm (8.86 KiB)已下载 1805 次。
Regards
vlookupImpl.sm (4.16 KiB)已下载 1780 次。
vlookupImpl2.sm (8.86 KiB)已下载 1805 次。
WroteCould 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
WroteVisit Samples next day or two ... gigantic Compendium.
lookup(value,table,col) ... working code.
Part 2 Discrete Systems
... just uploaded
WroteFiles 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
1页(11条)
- 有新帖
- 无新帖