lookup Options  Email this topic  Watch this topic  Print this topic » Normal Threaded

Previous Topic Next Topic

panzonet		#1 Posted : 19 October 2010 13:10:58(UTC)
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
User Profile View All Posts by User View Thanks

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

Andrey Ivashov		#2 Posted : 19 October 2010 14:28:28(UTC)
Rank: Administration Groups: Developers, Registered, Knovel Developers, Administrators, Advanced Member Joined: 11/07/2008(UTC) Posts: 1,622 Was thanked: 1983 time(s) in 668 post(s)		Here is example of vlookup(..) function definition for SMath Studio: Download: vlookupImpl.sm Regards.
		WWW
User Profile View All Posts by User View Thanks

panzonet		#3 Posted : 19 October 2010 15:14:58(UTC)
Rank: Newbie Groups: Registered Joined: 19/10/2010(UTC) Posts: 2 Location: genova, italy		thanks a lot, it works!
User Profile View All Posts by User View Thanks

Andrey Ivashov		#4 Posted : 19 October 2010 15:54:59(UTC)
Rank: Administration Groups: Developers, Registered, Knovel Developers, Administrators, Advanced Member Joined: 11/07/2008(UTC) Posts: 1,622 Was thanked: 1983 time(s) in 668 post(s)		Another possible implementation: Download: vlookupImpl2.sm.
		WWW
2 users thanked Andrey Ivashov for this useful post.		on 19/10/2010(UTC),  on 07/03/2023(UTC)
User Profile View All Posts by User View Thanks

MatFlanagan		#5 Posted : 16 September 2021 01:15:30(UTC)
Rank: Newbie Groups: Registered Joined: 14/09/2021(UTC) Posts: 1		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"
User Profile View All Posts by User View Thanks

overlord		#6 Posted : 16 September 2021 01:59:12(UTC)
Rank: Advanced Member Groups: Registered Joined: 23/07/2013(UTC) Posts: 1,173 Was thanked: 534 time(s) in 358 post(s)		Originally Posted by: MatFlanagan 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
User Profile View All Posts by User View Thanks

Divyang		#7 Posted : 09 October 2023 23:26:00(UTC)
Rank: Newbie Groups: Registered Joined: 25/09/2023(UTC) Posts: 2 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.
		WWW
User Profile View All Posts by User View Thanks

overlord		#8 Posted : 10 October 2023 00:28:26(UTC)
Rank: Advanced Member Groups: Registered Joined: 23/07/2013(UTC) Posts: 1,173 Was thanked: 534 time(s) in 358 post(s)		Files should be these ones. Regards vlookupImpl.sm (5kb) downloaded 63 time(s). vlookupImpl2.sm (9kb) downloaded 44 time(s).
User Profile View All Posts by User View Thanks

Jean Giraud		#9 Posted : 10 October 2023 14:42:05(UTC)
Rank: Guest Groups: Registered Joined: 04/07/2015(UTC) Posts: 6,866 Was thanked: 983 time(s) in 811 post(s)		Originally Posted by: MatFlanagan 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
User Profile View All Posts by User View Thanks

Jean Giraud		#10 Posted : 10 October 2023 17:51:10(UTC)
Rank: Guest Groups: Registered Joined: 04/07/2015(UTC) Posts: 6,866 Was thanked: 983 time(s) in 811 post(s)		Originally Posted by: Jean Giraud Visit Samples next day or two ... gigantic Compendium. lookup(value,table,col) ... working code. Part 2 Discrete Systems ... just uploaded
User Profile View All Posts by User View Thanks

Divyang		#11 Posted : 11 October 2023 04:51:11(UTC)
Rank: Newbie Groups: Registered Joined: 25/09/2023(UTC) Posts: 2 Location: Florida Was thanked: 1 time(s) in 1 post(s)		Originally Posted by: overlord Files should be these ones. Regards vlookupImpl.sm (5kb) downloaded 63 time(s). vlookupImpl2.sm (9kb) downloaded 44 time(s). Thank you!!
		WWW
1 user thanked Divyang for this useful post.		on 11/10/2023(UTC)
User Profile View All Posts by User View Thanks

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)