Topics   All   MacOS (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server   Client   Old   Deprecated   Guides   Examples   Videos
New in version: 12.2   12.3   12.4   12.5   13.0   13.1   13.2   13.3   13.4   13.5    Statistic    FMM    Blog  

Matrix.Lookup

Queries value without errors.

Component Version macOS Windows Linux Server iOS SDK
Matrix 13.5 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "Matrix.Lookup" { ; MatrixRef; Row; Column; Default Value } )   More

Parameters

Parameter Description Example Flags
MatrixRef The matrix reference number. $matrix Optional
Row The zero based row number.
Default is zero.
2 Optional
Column The zero based column number.
Default is zero.
2 Optional
Default Value The default value to return in case of an error. Optional

Result

Returns value or default value.

Description

Queries value without errors.
Retains original data type.
See also Matrix.GetValue function.

Examples

Try without parameters:

MBS("Matrix.Lookup")

Try with invalid row and column value:

let([
m = MBS("Matrix.New"; 3; 3);
r = MBS("Matrix.Lookup"; m; 5; 5; "test")
]; r)

Example result: test

Try with correct row and column:

let([
m = MBS("Matrix.New"; 3; 3);
s = MBS("Matrix.SetValue"; m; 2; 2; "value");
r = MBS("Matrix.Lookup"; m; 2; 2; "test")
]; r)

Example result: value

See also

Release notes

Blog Entries

This function checks for a license.

Created 24th September 2023, last changed 24th September 2023


Matrix.List - Matrix.Max

💬 Ask a question or report a problem