Hi How to set up two conditions for lookup?
Can you clarify your question?
LOOKUP() function is a short version of SELECT() that searches for a matching value in a column; if you have more conditions to check you could use SELECT() function instead.
Reza means something like… SELECT(Table[Column],AND(1stCondition,2ndCondition))
User | Count |
---|---|
16 | |
11 | |
9 | |
8 | |
4 |