Try this formula:
![]()
=IF(ISERROR(MATCH("*"&LEFT(C6,16)&"*",B:B,0)), "No", "Yes " &MATCH("*"&LEFT(C6,16)&"*",B:B,0))
Try this formula:
![]()
=IF(ISERROR(MATCH("*"&LEFT(C6,16)&"*",B:B,0)), "No", "Yes " &MATCH("*"&LEFT(C6,16)&"*",B:B,0))
Pierre Leclerc
_______________________________________________________
If you like the help you got,
Click on the STAR "Add reputation" icon at the bottom.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks