Creating a FAQ knowledge base with Excel.

Hi all,

What I am looking at creating is a kind of knowledge bank where the user can enter a key word and below will list all the relevant articles that are added to another page on the spreadsheet in.

Would this be possible? If so how would you go about it as I can't seem to wrap my head around even starting it

Originally Posted by JBeaucaire

I do this very thing in a lot of my documents. The trick is to include a simple indexing "key" on your articles page that is marking the relevant articles for you based on the current search string, then an INDEX/MATCH is bringing back that list of indexed articles. Example is attached.

Thanks for this.

What i was also wanting was to add an explanation for the article in column C in ARTICLES and add a large merged cell on the search sheet that will return this info if i click on it on the search sheet. Can i do this or would i have to add it so it returns all the info from all the found ARTICLES, so using a simple Vlookup?

thanks for your helps so far

Thanks for all help so far, I am afraid i have gone a bit more complicated, Please find attached a quick mock up of what i am trying to to which has multi parts that i cannot get to work.

So in the search page i still want it to return all the relevant articles but i would like it to search multiple pages, Is this even possible?
I am also looking at putting hyperlinks on all the searched articles that can link to a picture of said item but the index match doesnt return the hyperlink (set to a part of the document), i have tried to rectify this but it still doesn't work.
Also on the Search screen i would like, If possible for the Hyperlinked to show in the merged cell window i have added, Not sure if this is possible with Formula's?

Have i bitten off too much

Once again thanks for your helps so far.

Brilliant again, Thanks for this, It never ceases to amaze me how powerful Excel is, the spreadsheet has now changed as all these pictures would make the document far to large to use so i am looking at returning just written data.

What i am looking at doing is returning the articles in search and when i click the hyperlink returning the cell the hyperlink refers to into the large merged cell on Search sheet E2.

Is this even possible?

I would like to thank you for all your help so far, It has been very informative.

Hi,

The thread is a little old but wanted to check if someone can help me with this please.

In the first excel sheet shared, the second tab with the articles named "Articles", when I add formatting to the text within the cell, it does not reflect in the first sheet with the Articles (Where the formula is located)?

How do I get excel to retain the formatting added to the text from the second tab when it is shown in the first tab where the resulted articles appear? Such as heading of the article is bold etc?

Thank you in advance.

Ok, sorry and thank you.

Will start a new thread.