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

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


Download: vlookupImpl.sm

Regards.

thanks a lot, it works!

Another possible implementation:


Download: vlookupImpl2.sm.

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"

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

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 KiB) downloaded 95 time(s).
vlookupImpl2.sm (8 KiB) downloaded 69 time(s).

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

Wrote

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

... just uploaded

Wrote

Files should be these ones.
Regards

vlookupImpl.sm (4 KiB) downloaded 95 time(s).
vlookupImpl2.sm (8 KiB) downloaded 69 time(s).

Thank you!!