Hi How to set up two conditions for lookup?...

(Nino) #1

Hi How to set up two conditions for lookup?

(Philip Garrett) #2

Can you clarify your question?

(Reza Raoofi) #3

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.

(Aleksi Alkio) #4

Reza means something likeā€¦ SELECT(Table[Column],AND(1stCondition,2ndCondition))