Funtion
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,
James Kipling Changed status to publish
Hi Carlos,
Try to use this formula to the Result matrix:
F = select( Data::, @Data::G:A, Condition::G & “:” & Condition::A )
James Kipling Edited answer