this formula suddenly stopped working and I get a "#no match - can't figure out what happened

Cecelia

=IF(ISBLANK([SAGE Job#]@row), "", INDEX({Chessboard Const Start Date}, MATCH([SAGE Job#]@row, {Operations Chessboard Sage Job#}, 0)))

Paul Newcome

Are you able to provide some screenshots of the source and target sheets for reference / context?

Cecelia

This our main data sheet this feeds several other reports

but the date information come from another sheet

Cecelia

Paul Newcome

Try inserting a helper column into both sheets. They will both contain a column formula to convert all Sage Job #s into text strings like so:

=[Sage Job #]@row + ""

that's plus quote quote there after the column name.

Then use these columns in your MATCH function.