Hi,

Am Sat, 09 Mar 2013 23:09:59 GMT schrieb MAS:

I am more looking at a formula that will check the first 3 characters in
column A (i.e. A1C if A1C-123 is in a cell), then lookup column B starting
at row 3 in a different workbook, and return either "check" if the 3
characters appear in column B in the different workbook or "no" if it
doesn't.

you will get the row numbers fpr matches:
=SMALL(IF(LEFT([Mappe1.xlsx]Tabelle1!$B$1:$B$100,3)="A1C",ROW($1:$100)),ROW(A1 ))
ans copy down


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