## Excel comands on MathCAD

## Excel comands on MathCAD

(OP)

Hi!, i have a few questions:

1)I would like to use the command "vlookup" o "hlookup" on MathCAD, is there any way to put or use that on MathCAD?

2)In Excel if a put an answer, lets say:

="Use "&A1&" feet diameter bolt"

(where A1 is the cell that contains a number)

Now, how can i make that with MathCAD?

Thanks for any help!! :)

1)I would like to use the command "vlookup" o "hlookup" on MathCAD, is there any way to put or use that on MathCAD?

2)In Excel if a put an answer, lets say:

="Use "&A1&" feet diameter bolt"

(where A1 is the cell that contains a number)

Now, how can i make that with MathCAD?

Thanks for any help!! :)

## RE: Excel comands on MathCAD

You could insert a math region in the middle of the text string, but I find that it makes editing and future maintenance of the worksheet harder.

Q1 - I think you may have to write your own function to extract data from an array, using the in-built array indexing functions, if your data is table-based like Excel. Or just use an Excel component in Mathcad, and do all the lookup things inside it.

Bung

Life is non-linear...

## RE: Excel comands on MathCAD

Bung

Life is non-linear...

## RE: Excel comands on MathCAD

Q2 - I don't see it, can you put a expression to see? because as i understand you are saying that will end up something like this:

--> The answer is:

Bolt:=0.25in (let's say i put this inside an area so it won't show)

--> Now at the end of the sheet is this:

"Use this type of bolt" Bolt=0.25in

Is that what you're saying?? because i found that i can put the variable inside of the text, but still the word Bolt will still appear, like this:

"Use Bolt=0.25in diameter"

The thing is that i don't want the word Bolt to show, i just want:

"Use 0.25in diameter"

Is there a way to do that?? if not is ok, no problem.

==========================================================

Now i have a 3rd question:

In Excel i can use the command CHOOSE to choose a value from a list or something. Now i try searching in the help and every where for the CHOOSE command but i didn't found anything. This command exists in MathCAD?

## RE: Excel comands on MathCAD

Q3. That's because CHOOSE is the poor man's solution to not having indexed variables, which is directly supported in Mathcad:

i:0;10

x[i:blah_i

TTFN

## RE: Excel comands on MathCAD

## RE: Excel comands on MathCAD

TTFN

## RE: Excel comands on MathCAD

1- Start with the variable :

Bolt:=0.25in

2- Define the following strings:

a:="Use Bolt = "

_{include space within the quote}- Convert the number Bolt to strin:

b:=num2str(Bolt/1in)

_{Notice (Bolt/in)= number without unit.}c:= "in diameter"

3- Link together the 3 strins:

X:=concat(a,b,c)

Result:

X="Use Bolt=0.25in diameter"

_{NOTE: If portion of this need to be hidden for presentation purposes go to [insert] menu then [Area] and move the variable and text within the mark. Finally, double click to hide the desire area.}## RE: Excel comands on MathCAD

Ok, THAT'S WHAT I WAS TRYING TO SAY!!, is exactly what it is!!, THANK YOU VERY MUCH!!!, i just try it and perfect!!

To IRstuff:

This part:

i:0;10

x[i:blah_i

I don't understand that.

For now, thank you everybody to take tha time to do this, everything has been very helpfull.

## RE: Excel comands on MathCAD

TTFN

## RE: Excel comands on MathCAD

Hi, ok i try to put this:

i:0;10

x[i:blah_i

As it is on the sheet and doesn't work, because every time i try to put ":" puts me ":=", can you please do it on a sheet and the put a picture here, if is not to much, thanks!

## RE: Excel comands on MathCAD