Index and match not working

hi,

I have 2 sheets 1. LR_CNF and 2. Summary

LR_CNF sheet has container-wise loading data and we put BL no. against each container as
they sail and BL is issued.

in the Summary Sheet, UNDER BL STATUS we intent to summarize BL only. if BL Coloumn is blank it should not be
populated

the formula used was working initially and now it stopped and not pulling the BL nos after more
containeers are inserted in this sheet.

Kindly help is sorting the mistake if any in the formula or else advise.


Thanks
Ranbir