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

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