Trouble with combining MID and VLOOKUP

Originally Posted by JeteMc

Try pasting this formula into Email!G7:

Formula:

=IF(ISNA(MATCH("*"&MID(A7,1,8)&"*",Centre!D$18:D$45,0)),"NOT FOUND","")

Let me know if you have any questions.

Thanks, works perfectly. I knew I was close.