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

vlookup vactor vs. scalar output

SOLVED
ptc-5338546
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

Re: vlookup vactor vs. scalar output

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

Re: vlookup vactor vs. scalar output

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

Announcements
Check out the latest
Mathcad Tip
"PTC Mathcad 15 / Prime 1-6 Update."