Find & highlight that cell

[Abhijeet]

Hi

I have macro to find word & highlight that but i want if find then Column P Find mention in that row. Please tell me how to do this

 

[rrocker1405]

Hi Abhijeet,

There are two ways to do this. assumption here the search text "UA" is in cell P1 then use the search function to list it
=IFERROR(SEARCH(P1;B2;1);"")

or if you want to count the number of occurrence use the following
=IFERROR(LOOKUP(2;1/SEARCH(B2:O2;P1);B2:O2);"")

hope this helps.

Kind regards,
A!

 

[Abhijeet]

This is not work i want in Range B2:O2 if any find UA then P2 mention Find

 

[rrocker1405]

This is not work i want in Range B2:O2 if any find UA then P2 mention Find

Hi Abhijeet,
Request you to please confirm if you want to list the cell range in P2?

Kind regards,
A!

 

[Abhijeet]

yes