Skip to main content
P
ptc-53385461-Visitor
1-Visitor
November 22, 2013
Solved

vlookup vactor vs. scalar output

  • November 22, 2013
  • 1 reply
  • 1116 views

Hi Mathcad Users,

I am using PTC Mathcad Express Prime 3.0 for the first time.

In the attached file, I have G & w being pulled correctly using the vlookup function, but I would like the results in full Matrix format that I could then use for further work - Basically, I want my G & w matrices to look like G_desired & w_desired.

Any practical tips on how to accomplish this would be appreciated.

Thanks,

Joseph Thodiyil

Best answer by Werner_E

Maybe that way

it_Test2.png

BTW, in accessing the elements of a vector (= n x 1 matrix) you do not need to specify the second index (,0).

The [0 at the end of the lookup call return the first element of the vector which is returned by lookup. lookup has to return a vector as it may be that it finds more than one occurence of the given parameter.

1 reply

W
Werner_E25-Diamond IAnswer
25-Diamond I
November 22, 2013

Maybe that way

it_Test2.png

BTW, in accessing the elements of a vector (= n x 1 matrix) you do not need to specify the second index (,0).

The [0 at the end of the lookup call return the first element of the vector which is returned by lookup. lookup has to return a vector as it may be that it finds more than one occurence of the given parameter.

    Terms & ConditionsAccessibility statement