Problems with the lookup function for tables with units (Mathcad 15 M020)

[hjacobssonsandl]

I have problem using the lookup function for tables with units (all data in mm).

I was reccomended by a mathcad espert to use the built-in lookup function.

However, this lookup does not give correct results when searching in the first column when the table has a unit.

Does anyone have a solution for this?

[MikeArmstrong]

It should work with constant units.

Please post an example or the actual worksheet.

[hjacobssonsandl]

How do I add the file?

[MikeArmstrong]

Click 'Use Advanced Editor' top right hand corner and you will get the option to add files.

[hjacobssonsandl]

Here is the file

[MikeArmstrong · Accepted solution]

Increase TOL.

[Werner_E]

Mike Armstrong wrote:

Increase TOL.

Decrease TOL!! 😉

[MikeArmstrong]

Werner Exinger wrote:

Mike Armstrong wrote:

Increase TOL.

Decrease TOL!! 😉

Of course, well spotted

[ValeryOchkov]

Try please to change the CTOL built-in variable.

[hjacobssonsandl]

It does not help

[ValeryOchkov]

Helena Jacobsson Sandlund wrote:

It does not help

Your file can help us.

[Werner_E]

Helena Jacobsson Sandlund wrote:

It does not help

You are right. Its not CTOL you have to change, but TOL as Mike already showed in his file.

[ValeryOchkov]

Werner Exinger wrote:

Helena Jacobsson Sandlund wrote:

It does not help

You are right. Its not CTOL you have to change, but TOL as Mike already showed in his file.

In the past we have only TOL not TOL and CTOL. It was my error! Sorry.