Is it possible to use the SELECT() function with multiple criteria

I would like to have something like this:
If [Next Valid Pay Date] = [_THISROW].[Next Valid Pay Date]
and [Day You Get Paid] = [_THISROW].[Day You Get Paid])
then SELECT(Sheet1[Pay Code]

Thanks for the help in advance

Solved Solved
0 5 411
1 ACCEPTED SOLUTION

Just wrap the โ€œwhereโ€ part with AND
SELECT(Sheet1[Pay Code],AND([Next Valid Pay Date] = [_THISROW].[Next Valid Pay Date],[Day You Get Paid] = [_THISROW].[Day You Get Paid]))

View solution in original post

5 REPLIES 5

Aaron_Blau
Participant III

Yes, you wrap the multiple criteria in an AND expression

AND([Account Name]=[Rep],Year([Created Date])

AND(SELECT(Sheet1[Pay Code],[Next Valid Pay Date] = [_THISROW].[Next Valid Pay Date],[Day You Get Paid] = [_THISROW].[Day You Get Paid]))

did I do something wrong because it did not work

Just wrap the โ€œwhereโ€ part with AND
SELECT(Sheet1[Pay Code],AND([Next Valid Pay Date] = [_THISROW].[Next Valid Pay Date],[Day You Get Paid] = [_THISROW].[Day You Get Paid]))

Aaron thank you so much

Exactly the result I was looking for

Nice, happy I could help

Top Labels in this Space