creating a help/FAQ spreadsheet in excel

February 3, 2012 at 04:23:20
Specs: Windows XP
I need a formula that will allow the user to enter a question, excel will then return exact/similar matches, preferably in order of closest match, and the corresponding answers.

Any ideas on how to do this?

Thanks in advance.

See More: creating a help/FAQ spreadsheet in excel

Report •

February 3, 2012 at 11:18:21
What your asking could probably be done in Excel, but it would not be easy.
Excel is not designed to work with words and phrases.
It's focus in on crunching numbers.

What you need a regular database program.
Something like Access.

Here are a couple of links that might help:


Report •
Related Solutions

Ask Question