I applied the following formula to find the matching and write the data of
the corresponding next cell.

Sheet1.
the column C:C has custom format 000-000 having the data like this
123-456 12
001-789 11
313-245 13
456-779 16
084-321 18

IF(ISNA(MATCH(D5,Sheet1!C:C,0)),"Not exist",Sheet1!D2).
the matching is working but after, it is not writing corresponding data
from D2 value. It will put the data from skipping two row. Please help

Active sheet
The column B1 has the following data
ABC123456
DSD001789
HGH084321
YYY343434

like this 7500 record exist.





With thanks
Pol