Welcome Guest! To enable all features please Login. New Registrations are disabled.

Notification

Icon
Error

Login


Options
Go to last post Go to first unread
Offline panzonet  
#1 Posted : 19 October 2010 13:10:58(UTC)
panzonet

Rank: Newbie

Groups: Registered
Joined: 19/10/2010(UTC)
Posts: 2
Location: genova, italy

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

Wanna join the discussion?! Login to your SMath Studio Forum forum account. New Registrations are disabled.

Offline Andrey Ivashov  
#2 Posted : 19 October 2010 14:28:28(UTC)
Andrey Ivashov


Rank: Administration

Groups: Developers, Registered, Knovel Developers, Administrators, Advanced Member
Joined: 11/07/2008(UTC)
Posts: 1,616
Man
Russian Federation

Was thanked: 1978 time(s) in 666 post(s)
Here is example of vlookup(..) function definition for SMath Studio:


Download: vlookupImpl.sm

Regards.
Offline panzonet  
#3 Posted : 19 October 2010 15:14:58(UTC)
panzonet

Rank: Newbie

Groups: Registered
Joined: 19/10/2010(UTC)
Posts: 2
Location: genova, italy

thanks a lot, it works!

Offline Andrey Ivashov  
#4 Posted : 19 October 2010 15:54:59(UTC)
Andrey Ivashov


Rank: Administration

Groups: Developers, Registered, Knovel Developers, Administrators, Advanced Member
Joined: 11/07/2008(UTC)
Posts: 1,616
Man
Russian Federation

Was thanked: 1978 time(s) in 666 post(s)
Another possible implementation:


Download: vlookupImpl2.sm.
thanks 2 users thanked Andrey Ivashov for this useful post.
on 19/10/2010(UTC),  on 07/03/2023(UTC)
Offline MatFlanagan  
#5 Posted : 16 September 2021 01:15:30(UTC)
MatFlanagan

Rank: Newbie

Groups: Registered
Joined: 14/09/2021(UTC)
Posts: 1
United States

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"
Offline overlord  
#6 Posted : 16 September 2021 01:59:12(UTC)
overlord


Rank: Advanced Member

Groups: Registered
Joined: 23/07/2013(UTC)
Posts: 1,125
Turkey

Was thanked: 506 time(s) in 337 post(s)
Originally Posted by: MatFlanagan Go to Quoted Post
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
Offline Divyang  
#7 Posted : 09 October 2023 23:26:00(UTC)
Divyang

Rank: Newbie

Groups: Registered
Joined: 25/09/2023(UTC)
Posts: 2
United States
Location: Florida

Was thanked: 1 time(s) in 1 post(s)
Hello, I am trying to download the files but the link leads me to the main website. Please help.
Offline overlord  
#8 Posted : 10 October 2023 00:28:26(UTC)
overlord


Rank: Advanced Member

Groups: Registered
Joined: 23/07/2013(UTC)
Posts: 1,125
Turkey

Was thanked: 506 time(s) in 337 post(s)
Files should be these ones.
Regards

vlookupImpl.sm (5kb) downloaded 39 time(s).
vlookupImpl2.sm (9kb) downloaded 28 time(s).
Offline Jean Giraud  
#9 Posted : 10 October 2023 14:42:05(UTC)
Jean Giraud

Rank: Guest

Groups: Registered
Joined: 04/07/2015(UTC)
Posts: 6,868
Canada

Was thanked: 980 time(s) in 808 post(s)
Originally Posted by: MatFlanagan Go to Quoted Post
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
Offline Jean Giraud  
#10 Posted : 10 October 2023 17:51:10(UTC)
Jean Giraud

Rank: Guest

Groups: Registered
Joined: 04/07/2015(UTC)
Posts: 6,868
Canada

Was thanked: 980 time(s) in 808 post(s)
Originally Posted by: Jean Giraud Go to Quoted Post
Visit Samples next day or two ... gigantic Compendium.
lookup(value,table,col) ... working code.
Part 2 Discrete Systems

... just uploaded
Offline Divyang  
#11 Posted : 11 October 2023 04:51:11(UTC)
Divyang

Rank: Newbie

Groups: Registered
Joined: 25/09/2023(UTC)
Posts: 2
United States
Location: Florida

Was thanked: 1 time(s) in 1 post(s)
Originally Posted by: overlord Go to Quoted Post
Files should be these ones.
Regards

vlookupImpl.sm (5kb) downloaded 39 time(s).
vlookupImpl2.sm (9kb) downloaded 28 time(s).


Thank you!!
thanks 1 user thanked Divyang for this useful post.
on 11/10/2023(UTC)
Users browsing this topic
Similar Topics
Matrix Lookup (Samples)
by Jean Giraud 06/01/2024 14:08:48(UTC)
lookup 30405 (Samples)
by Jean Giraud 11/10/2023 16:09:11(UTC)
lookup fuction (Questions)
by soomoon 06/03/2023 11:02:40(UTC)
LOOKUP Compendium (Samples)
by Jean Giraud 16/09/2021 19:06:38(UTC)
Lookup TREASURY (Samples)
by Jean Giraud 23/04/2020 17:20:03(UTC)
Vlookup Delay (Questions)
by ndtma 18/02/2018 18:15:39(UTC)
Data Table Parsing Function - Intelligent VLOOKUP() (Questions)
by Alex M. 03/01/2017 03:33:38(UTC)
using lookup function not work in sqrt command (Questions)
by xyonx 17/05/2012 13:10:08(UTC)
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.