Array formula to search multiple columns for character string in a list

[tgk]

Can an array formula search multiple columns for a string of characters in a list?
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
The list is a series of codes, which can be arranged in a row, in a column or even in a single cell.
<o></o>
The spreadsheet has 3 columns. The cells in the columns may be empty, or may contain a string of characters. Some rows will contain cells with duplicate strings, and some may have iterations of the same string in several cells (see rows 5 and 6 in the example below).
<o></o>
The first 4 characters of each string will contain one of the listed codes.
<o></o>
Any suggestions are welcome.
<o></o>
Thanks!
<o></o>
<o></o>
...........A...........................................B......................... C.........................
1.. 5210-5090-R-SUM3........5210-5090-R-SUM3....................................
2...........................................9610-5090-R-SUMM..................................
3...........................................5410-5090-R-FALL.........5410-5090-R-FALL
4.. 5243-5090-10STOR............................................................................
5.. 5243509010STOR...........5243509010STORCL...................................
6.. 9228................................9228-050........................92285050BSA......

Codes
5210
5243
5410
5723
9228
9610

 

[schielrn]

So what are your expected results here? Are you wanting to see if your list of codes exists in the data somewhere in A1:C6 in the first 4 characters?

 

[tgk]

Sorry! The result ideally would be the code string it finds.

 

[schielrn]

Based on what I said before:

Excel Workbook
	A	B	C
1	5210-5090-R-SUM3	5210-5090-R-SUM3
2		9610-5090-R-SUMM
3		5410-5090-R-FALL	5410-5090-R-FALL
4	5243-5090-10STOR
5	5243509010STOR	5243509010STORCL
6	9228	9228-050	92285050BSA
7
8	Codes
9	5210	Exists
10	5243	Exists
11	5410	Exists
12	5723	Doesn't Exist
13	9228	Exists
14	9610	Exists
Sheet2

Cell Formulas
Range	Formula
B9	=IF(COUNTIF($A$1:$C$6,A9&"*") > 0,"Exists","Doesn't Exist")
B10	=IF(COUNTIF($A$1:$C$6,A10&"*") > 0,"Exists","Doesn't Exist")
B11	=IF(COUNTIF($A$1:$C$6,A11&"*") > 0,"Exists","Doesn't Exist")
B12	=IF(COUNTIF($A$1:$C$6,A12&"*") > 0,"Exists","Doesn't Exist")
B13	=IF(COUNTIF($A$1:$C$6,A13&"*") > 0,"Exists","Doesn't Exist")
B14	=IF(COUNTIF($A$1:$C$6,A14&"*") > 0,"Exists","Doesn't Exist")

 

[schielrn]

After reading what you just stated, you want to create the code list that is below the data?

 

[tgk]

If the formula finds a matching code in columns A, B, or C, can it show the matching code in column D of each row? Some rows will not have a matching code, so those answers can be blank, an asterick, whatever.