Doing a search for text within a cell with alot of text.

[Cakin]

Hello,

I'm trying to figure out how i could search like a vlookup for say something like "%12FIRE" from one sheet to another but, the other sheet has allot more text in the cell so it might say something like "added %12FIRE to the model and it was good"

Then i need it to give me a confirmation that it was found or if it was not in the cell next to the name.
An example sheet it attached, any help would be appreciated.

[tigeravatar]

Cakin,

Attached is a modified version of your sample workbook. In sheet 'Names' cell B2 is the formula:
=IF(COUNTIF(Text!B:B,"*"&A2&"*")>0,"Y","N")

And then its copied down

Hope that helps,
~tigeravatar

[Cakin]

Cakin,

Attached is a modified version of your sample workbook. In sheet 'Names' cell B2 is the formula:
=IF(COUNTIF(Text!B:B,"*"&A2&"*")>0,"Y","N")

And then its copied down

Hope that helps,
~tigeravatar

Wow, thats kind of fancy thank you very much you saved me tons of time.