how to get hlookup to output a scalar
how to get hlookup to output a scalar
(OP)
I'm trying to get the hlookup function to output a value of a matrix given a string or value to match in a header row, the lookup matrix, and known row number. i.e.
seed:= "ex"
R: [0 "ex" 1
2 3 4
5 6 7]
As I have it written now, MathCAD outputs
solution:= hlookup(seed,R,2)= (3)
I would like hlookup(seed,R,2) to output the just scalar value of the matrix entry instead of the vector. Is there a setting or another function to "scalarize" the output? The vlookup() function has the same issue. I'd like to use hlookup or vlookup, so the seed can be a prompted string or value.
Thanks for any help.
seed:= "ex"
R: [0 "ex" 1
2 3 4
5 6 7]
As I have it written now, MathCAD outputs
solution:= hlookup(seed,R,2)= (3)
I would like hlookup(seed,R,2) to output the just scalar value of the matrix entry instead of the vector. Is there a setting or another function to "scalarize" the output? The vlookup() function has the same issue. I'd like to use hlookup or vlookup, so the seed can be a prompted string or value.
Thanks for any help.





RE: how to get hlookup to output a scalar
solution:hlookup(seed,R,2)[0 or [1
since it looks like your origin is set to 1 and not 0
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: how to get hlookup to output a scalar