Matching a Name to another sheet and is checking a row if it is a date

Paul Mangan

=IF(AND(MATCH([Team Member]@row, {Team Member}, 0), ISDATE({L1 Mixer})), 1, "")

This is what I try and it returns incorrect argument set on the first row, but invalid data type on the remainder. It is a column formula.

Kelly Moore

Hey @Paul Mangan

Try this formula instead

=IF(COUNTIFS({Team Member},[Team Member]@row,{L1 Mixer},ISDATE(@cell))>0,1)

Will this work for you?

Kelly