Trying to create a simple Troubleshooting form a bit like a scaled down version of the Microsoft Knowledge Base. When you input a keyword it returns the closest value which would be the heading. Below that would be the instructions to follow (not included in search). The idea that it either returns a list close to what needs to be searched for which I think Excel wouldnt do or jump to the nearest value of what was entered which I think Excel can do.


I have created an input box but am unsure how to tie it into the items in a list. Can it jump down to where that item is and if it can is it possible to jump to the next closet value (i.e. like F3 when doing a text search).

Appreciate any help offered. Apologies if this is a repeat of other posts but after the 5th post I reliased that I am unable to find exactly what I am after.
Thanks.