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