Try pasting this formula into Email!G7:Let me know if you have any questions.Formula:
=IF(ISNA(MATCH("*"&MID(A7,1,8)&"*",Centre!D$18:D$45,0)),"NOT FOUND","")
Try pasting this formula into Email!G7:Let me know if you have any questions.Formula:
=IF(ISNA(MATCH("*"&MID(A7,1,8)&"*",Centre!D$18:D$45,0)),"NOT FOUND","")
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks