Funtion

Generic selectors
Exact matches only
Search title only
Search in content
Search in all posts
Search in pages
Answers
Questions
Solved2.40K viewsFormulas and Functions
0

Hi

I need some help. I´m stuck.

I wanna bring a specific value from another matrix, depending from a condition. I usually use the "IF" formula, but in this case I have a lot of condition so this is not an option.

I have been trying with lookup, match and select formula but does not work or at least no in the way I’m writing it.

I´m not sure if you did understand my problem so I attached an example.

In this example I have three matrices "Data", "Condition" (the condition for the value i´m looking at) and "Result" (matrix with the value).

Thanks,

Changed status to publish

Attachments

Example.model
1

Hi Carlos,
Try to use this formula to the Result matrix:

F = select( Data::, @Data::G:A, Condition::G & “:” & Condition::A )

Edited answer
You are viewing 1 out of 2 answers, click here to view all answers.

Latest Questions