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 |
---|---|
42 | |
28 | |
25 | |
22 | |
13 |