Looking for a formula to mark up in cells when data missing from specific columns

[ghrek]

Hi im trying to find a formula that looks at data in lets say row 2 in columns I-L and then trys to find in columns B-E in any row.

If it dont find an exact match I need it marking up "MISSING". I have the formula below that is in column F and looks in columns I-L and have tried reversing but it not working.

=IF([@Source]="","",IF(ISNA(MATCH([@ID]&[@Field2]&[@Date]&[@Value],INDEX($I$2:$I$9999&$J$2:$J$9999&$K$2:$K$9999&$L$2:$L$9999,),0)),"Missing",""))

Any ideas?

Thanks

 

[Peter_SSs]

Any ideas?

Could you show us (XL2BB) a small set of dummy data with the expected results and explain again in relation to that?

 

[ghrek]

Will do but won’t be until later