Skip to main content
R
Ramakr561-Visitor
1-Visitor
May 9, 2017
Question

How to use VLOOKUP related to a table in MATHCAD Prime

  • May 9, 2017
  • 1 reply
  • 11245 views

Hi Every one

In MathCAD 15 I was able to use vlookup referred to the tables inside the worksheet

because any table has a specific name but because in Mathcad Prime there is no name related to table I can not do that at all

I do know How to can do the the same in Prime without using excel

I do not like using excel entire worksheet because every time you have to double click on it & going to another program in fact , it is also take unnecessarily time,

It would be your kind if you find any solution in this regards except using Matrix

Mathcad 15 Tables.png

1 reply

W
Werner_E25-Diamond I
25-Diamond I
May 10, 2017

I don't understand your question. Your picture shows part of a Mathcad 15 worksheet and all I see here could be done the very same way in Prime, too.

A "table" in Mathcad (15 or below) always is and was a simple matrix - the "tables" G and H you show are matrices. So what do you mean by "except using matrix"?

In Prime there was introduced a way to define a number of vectors in a display they named "table". Its quite unusable for larger data you import as you can fill those table only manually. Basically when you use that tables you have column headers which are the names of the vectors you create.

If you have created that kind of table instead of your matrix G and if you named the columns in that table Gcol1, Gcol2, Gcol3, etc (you sure would chose other names), then you can use

lookup(LFRS,Gcol1,Gcol3)[1

instead of

vlookup(LFRS,G,3)[1

Looks like you have changed ORIGIN from default 0 to 1.

R
Ramakr561-VisitorAuthor
1-Visitor
May 12, 2017

Hi Werner!

Thanks for your time & answer

it seems I could not show what exactly I am looking for , I tried to attach two new image, as you see here in mathcad 15 we can easily use VLOOKUP

but as you can see I can not do the the same in MathCad prime because  tables in the prime does not have any name so I can not define second parameter of

vlook up in there....

Vlook up 15.jpg                                    Vlook up Prime.jpgjavascript:;

N
nas0k1-Visitor
1-Visitor
May 12, 2017

You used a table in Prime. Not the same as an matrix:

I hope this helps.

    Terms & ConditionsCookie settingsAccessibility statement