Help with searching for text and then displaying it.

Is there a certain formula or function that can help with searching a bunch of columns until the columns stop and then making a new column with that text that is found? I need to search for different versions of the text, too.

Here is an example.
"CAP CER 0.1UF 50V Y5V 0603" I need to find the text "0603" in this cell.
"DIODE ZENER 2.2V 250MW SOD323" I need to find the text "SOD323" in this cell. But sometimes it might be SOD-323. Also it needs to check for "0603" as well.
I tried making a whole bunch of nested IF statements but there are so many that I need to search for that the statement is getting too long. Is there a way to check it against a table I make in another spreadsheet with all the terms I need to search for? What would be the best method to approach this? I tried to record a Macro but that only records me pasting my clipboard and not pasting this code.
Here is my formula so far: =IF(ISNUMBER(SEARCH("0603",H2)),"0603",IF(ISNUMBER(SEARCH("0805",H2)),"0805",IF(ISNUMBER(SEARCH("1206",H2)),"1206",IF(ISNUMBER(SEARCH("2917",H2)),"2917",IF(ISNUMBER(SEARCH("0402",H2)),"0402",IF(ISNUMBER(SEARCH("0201",H2)),"0201",IF(ISNUMBER(SEARCH("1210",H2)),"1210",IF(ISNUMBER(SEARCH("SOT23",H2)),"SOT23",IF(ISNUMBER(SEARCH("SOD123",H2)),"SOD123",IF(ISNUMBER(SEARCH("CONN",H2)),"CONN",IF(ISNUMBER(SEARCH("SOT-23",H2)),"SOT-23",IF(ISNUMBER(SEARCH("tssop",H2)),"TSSOP",IF(ISNUMBER(SEARCH("8SOIC",H2)),"8SOIC",IF(ISNUMBER(SEARCH("14SOIC",H2)),"14SOIC",IF(ISNUMBER(SEARCH("2220",H2)),"2220",IF(ISNUMBER(SEARCH("HC-49/US",H2)),"HC-49/US",IF(ISNUMBER(SEARCH("QFN",H2)),"QFN",IF(ISNUMBER(SEARCH("2512",H2)),"2512",IF(ISNUMBER(SEARCH("8-SOIC",H2)),"8-SOIC","Not Found")))))))))))))))))))


Please help.
Thanks in advance.