Try pasting this formula into Email!G7:
Formula: copy to clipboard
=IF(ISNA(MATCH("*"&MID(A7,1,8)&"*",Centre!D$18:D$45,0)),"NOT FOUND","")
Let me know if you have any questions.