Hello,
I have created date columns with (Restrict to dates only) off. I am returning the correct dates in the correct columns. However, August is returning #NO MATCH in blank columns, I would like for these columns to remain blank until a date is added. Formulas for both columns are listed below.
July Formula
=IFERROR(INDEX({July Completion of OSV+ Attestation Form R Range 1}, MATCH([Email Address]@row, {July Completion of OSV+ Attestation Form R Range 2}, 0)), "")
August Formula
=IFERROR(INDEX({August Completion of OSV+ Attestation For. Range 1}, MATCH([Email Address]@row, {August Completion of OSV+ Attestation For. Range 2}, 0))"")
Any assistance is appreciated.