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
|