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 |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |