Funtion

Solved4.53K 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,

Attachments

Example.model

Latest Questions

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