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

Community Tip - Need help navigating or using the PTC Community? Contact the community team. X

vlookup vactor vs. scalar output

ptc-5338546
1-Newbie

vlookup vactor vs. scalar output

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

1 ACCEPTED SOLUTION

Accepted Solutions

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.

View solution in original post

1 REPLY 1

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.

Top Tags