View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
micmed
 
Posts: n/a
Default compare data from 2 columns

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

"Stephen" wrote:

Have you tried the vlookup function?

"micmed" wrote:

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