display search items

[baynoli]

Hi I have a worksheet with a list of different documents and forms, some titles contain same text as other documents, i.e.doc1="safety monitoring form", doc2="maintenance monitoring process". My question is that, is there a formulas that i can use to display these documents, say these examples if i search the word monitoring it will display the documents that contain the word monitoring.


Its like a search feature in in ms windows that display all result containing the searched word.


Thanks,


baynoli

 

[Faseeh]

Hi baynoli,


See this attached file whether it is appropriate or not?? The formula searches for certain text in a range of cells that contain your file names and returns search in another column.


http://www.4shared.com/file/TLWpgHZa/baynoli.html


Regards,

FASEEH

 

[Faseeh]

Hi baynoli,


A little mistake. "Replace" the formula in cell C4 with this one:

=IFERROR(OFFSET($A$1,SMALL($B$4:B10000,ROW(A1))-1,0),"-")and drag down.

Now it is giving correct result. (The Cell Reference in OFFSET()was set as A2 instead of A1 and that was problematic), or simply download corrected file...


http://www.4shared.com/file/uP52Ur9k/baynoli_corrected.html


Faseeh