Solved4.54K viewsFormulas and Functions


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).




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

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

S A U edited answer October 29, 2018
You are viewing 1 out of 2 answers, click here to view all answers.

Latest Questions

Qloud Losing Formatting 4 Answers | 0 Votes
Meditation on timelines 3 Answers | 0 Votes