Hi,

Since your Source table range C2:I8 data is generated from formula and causing Circular References error.

I converted all your C2:I8 formula result into value

Then, In J2 CSE formula copied down :

=IF(INDEX(C2:I2,LARGE(IF(C2:I2<>"",COLUMN(C$1:I$1)-COLUMN(B$1)),2))&INDEX(C2:I2,LARGE(IF(C2:I2<>"",COLUMN(C$1:I$1)-COLUMN(B$1)),1))="0-","To Check","No Check")

View attachment 80460