cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

vlookup from a table

SOLVED
Newbie

vlookup from a table

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!

1 ACCEPTED SOLUTION

Accepted Solutions

Re: vlookup from a table

Hello!

Please see the attachment.

12 REPLIES 12

Re: vlookup from a table

Hello!

Please see the attachment.

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

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?

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.

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.

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

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?

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

Re: vlookup from a table

The same result:

Pic_1.jpg

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