Search entire column data in a another column

[PANIGGR]

I have column A with random data alpha and alpha numeric. Column C with specific orderly data. I need to search value of column C exists in any section of column A. If yes then it should highlight in column B and update the the value.

Aptus Utilitie A7MWUO5V	A7MWUO5V	A3IPM3117C
snd vnvnnnkn		A39SYRN <colgroup><col width="83"></colgroup><tbody> </tbody>
gmsnn A1U040ZX 35454	A1U040ZX	A2H7QHYJ3 <colgroup><col width="83"></colgroup><tbody> </tbody>
A1U040ZX7987ae0090	A1U040ZX	A7MWUO5V <colgroup><col width="83"></colgroup><tbody> </tbody>
wgags80980		A2Z9KP <colgroup><col width="83"></colgroup><tbody> </tbody>
aga9-098-0 A39SYRN	A39SYRN	A1U040ZX <colgroup><col width="83"></colgroup><tbody> </tbody>
ggrg0= A1U040ZX 098233	A1U040ZX	A1DN5HDW <colgroup><col width="83"></colgroup><tbody> </tbody>

<tbody>
</tbody>

Regards,
Radhakant

 

[Fluff]

In that case I don't understand why you would get the #NAME? error, as that means Xl does not recognise the function name

 

[PANIGGR]

In that case I don't understand why you would get the #NAME ? error, as that means Xl does not recognise the function name

It worked, earlier i entered the code in the sheet1 excel object module, now i entered in standard module...thank you so much

 

[Fluff]

Glad it's sorted & thanks for the feedback