Hi,

I have an issue with the attached file.

I am looking to tag the first worksheet (ALL) with a "1" each time the second worksheet (Closed) contains a value which also sits in the first worksheet.

I have entered
=INDEX(Closed!$A$2:$A$1500,1,MATCH(A2,Closed!$A$2:$A$1500,0))

But the formula only picks up one set of values.

Anybody advise please.

File attached

Terry