Skip to main content
ptc-42609121-Visitor
1-Visitor
November 7, 2011
Solved

vlookup from a table

  • November 7, 2011
  • 12 replies
  • 6817 views

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!

Best answer by VladimirN

Hello!

Please see the attachment.

12 replies

VladimirN24-Ruby IVAnswer
24-Ruby IV
November 7, 2011

Hello!

Please see the attachment.

ptc-42609121-VisitorAuthor
1-Visitor
November 7, 2011

Thank you so much Vladimir!

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

wayne12-Amethyst
12-Amethyst
November 7, 2011

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.

Terms & ConditionsAccessibility statement