Get Help

Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Community
- :
- PTC Mathcad
- :
- PTC Mathcad
- :
- Re: vlookup from a table

Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

11-07-2011
09:38 AM

11-07-2011
09:38 AM

Hello,

when i look up a value from a table the answer always has parentheses.is there something in Mathcad other than vlookup where i can lookup values but w/p parentheses. please see attached mathcadsheet. The user pick a beam size, then i would like to be able to read its root beams from column 1 and 2. Also i would like to be able to look up other values as well w/o parentheses. Thank you all!

Solved! Go to Solution.

Labels:

1 ACCEPTED SOLUTION

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

11-07-2011
09:48 AM

12 REPLIES 12

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

11-07-2011
09:48 AM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

11-07-2011
10:58 AM

11-07-2011
10:58 AM

Re: vlookup from a table

Thank you so much Vladimir!

did you add the 0 by "[ "? could you explain to what does the step you did do?

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

11-07-2011
10:58 AM

11-07-2011
10:58 AM

Re: vlookup from a table

Thank you so much Vladimir!

did you add the 0 by "[ "? could you explain to what does the step you did do?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

11-07-2011
11:07 AM

11-07-2011
11:07 AM

Re: vlookup from a table

vllookup is returning a matrix, even though it is only one element, that's what the () indicated, so by using [0, you are selecting the first element in the matrix, which is a number.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

11-08-2011
04:24 AM

11-08-2011
04:24 AM

Re: vlookup from a table

SAM FARES wrote:

Thank you so much Vladimir!...

You're welcome.

SAM FARES wrote:

...did you add the 0 by "[ "?...

Yes .

SAM FARES wrote:

... could you explain to what does the step you did do?

Please see the correct explanation from Wayne at the top.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

11-08-2011
05:11 AM

11-08-2011
05:11 AM

Re: vlookup from a table

There is an issue with Vladimir's way. What happens when there are two matches?????

Using the [0, the function will only return the first match.

Mike

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

11-08-2011
05:51 AM

11-08-2011
05:51 AM

Re: vlookup from a table

Mike,

Something wrong with this worksheet. At me Mathcad 15 M010 was closed with an error. Could you check it?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

11-08-2011
05:56 AM

11-08-2011
05:56 AM

Re: vlookup from a table

Please try the attached. I was only indicating that the [0 trick will not work when more than 1 match is found.

Mike

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

11-08-2011
06:00 AM

11-08-2011
06:00 AM

Re: vlookup from a table

The same result:

Try to download this file ("**Mathcad lookup_MC15_Mike.xmcd.zip**") and then open it.

Top Tags