It adds parenthesis around any calculation done using those values. IRstuff was correct about the matrix and I found that I could get rid of the parenthesis just by adding [0 to my vlookup formulas. When I first recreated your formulas I left out the subscript 1 (or [1 ) that you had because I...
Thanks again. I have one last question. All my values for the properties get returned with parenthesis around them. Is there a way to get rid of this? I notice that it does not happen with yours.
Thanks so much for your help. I was able to replicate your reply in my own file. Do you know if there is a way to automate the properties part tho? So that it would give me the properties immediately after defining a member rather than having to repeat each vlookup command?
Hi all, I'm a total newbie to MathCAD 15 but I am wondering if anyone could provide some guidance on how to insert an Excel file into MathCAD that would then allow me to define a certain cell in that file and have MathCAD return values from other cells. Basically what I am trying to do is link...