Thanks TMS

When I copy the formula & paste in the cell A6, it give me 0. But is should give me 19233 as that is the Lease ID. Can you please advise?

Thanks & Regards
Arpan