Hi,

Am Sat, 09 Mar 2013 07:56:42 GMT schrieb MAS:


I am looking for help with a formula that will look up the first 3
characters in a cell, compare it too a table in a different workbook and
return the result of "check" if the 3 characters match an entry in the
table

if you want to count the matches try:
=COUNT(SEARCH(LEFT(A1,3),[MyWorkbook.xlsx]Sheet1!$A$1:$A$100))

Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2