New lookup function

Forum|Forum|15 years ago
July 15, 2010
1 reply
16689 views

I am trying to write a function which is similar to Mathcad’s built in lookup functions. I have managed to write a basic version which will accept a variable ‘n’ as a decimal (the function rounds the variable to the nearest whole number) and return the corresponding values from the Matrix ‘cc’ using the predefined function subvector.

The reason for the function is to allow the user to extract the required values from the table to allow for interpolation.

Any criticism or improvements are welcome.

Mike

1_Lookup-example-mcd.zip

Other

M

MikeArmstrong

Author

1-Visitor

I have improved my function by adding additional arguments to it.

At the moment the function can only take c1 as the first column of the Matrix cc due to the rounding, because the first column of Matrix cc is numbered 1..9 when a decimal is inserted as argument n the function can either round up or down to the nearest whole number.

But this isn't the case if say, n is changed to 88 and c1 changed to matrix column 1 for example.

This is work in progress, just thought it might help other collabs with the development of the sheet.

Mike

1_Lookup-example2-mcd.zip