The formulas I sent you will do that. Put one into the appropriate cell,
change the criteria to what you want to search for, adjust the cell
references to suit and drag the formula down to the end of your list.
"Trumpet" wrote in message
...
What I want is that I create one formula and paste it in all the 500
cells.
the formula will search in every cell of column A to find a partial match
in
column B