software

I need a formula that will allow me to search a column (B1:B19989) that
contains text with the data from a column (A1:A32417) that contains a list of
part numbers and display a result(True/False) into another column (C). Column
B's text has the part numbers mixed in with the text. I need to know which
numbers from column A are found within the text of column B.

I have tried many of the example sulutions from this group and cannot get
them to work. Thanks in advance

Have you tried the vlookup function?

quot;micmedquot; wrote:

gt; I need a formula that will allow me to search a column (B1:B19989) that
gt; contains text with the data from a column (A1:A32417) that contains a list of
gt; part numbers and display a result(True/False) into another column (C). Column
gt; B's text has the part numbers mixed in with the text. I need to know which
gt; numbers from column A are found within the text of column B.
gt;
gt; I have tried many of the example sulutions from this group and cannot get
gt; them to work. Thanks in advance

Yes I have but can't seem to get the syntax right. I keep getting the #N/A
error.

quot;Stephenquot; wrote:

gt; Have you tried the vlookup function?
gt;
gt; quot;micmedquot; wrote:
gt;
gt; gt; I need a formula that will allow me to search a column (B1:B19989) that
gt; gt; contains text with the data from a column (A1:A32417) that contains a list of
gt; gt; part numbers and display a result(True/False) into another column (C). Column
gt; gt; B's text has the part numbers mixed in with the text. I need to know which
gt; gt; numbers from column A are found within the text of column B.
gt; gt;
gt; gt; I have tried many of the example sulutions from this group and cannot get
gt; gt; them to work. Thanks in advance

If possible you can change the columns into text file,then you can try
Texteer software at: www.texteer.com
It provides several functions in which quot;Include Comparequot; function maybe
can solve your problem.The quote
page:www.texteer.com/windows/b0.sb1.1.htm