search data and display results like a Google type search box

[cfcoetzer]

Hi

I'm new to advanced excel and need to create a google like search box to pull up information form a spreadsheet wit information.

I want to use sheet1 as the sheet where the google like search box sits and where the results of the search will display. the information it is pulling form is in sheet2 . when entering a search it should then link to the key search work column and if there is a match it must then pull up the entire row (from column A to E)of information. it should also show the multiple results matches.

Can somebody please help me on how I can do this step by step.


Appreciate the help!



Christian

[Mumps1]

What is the search word column in Sheet2? Will you want to search for a single word? Please explain referring to specific cells, rows, columns and sheets using a few examples from your data.

[cfcoetzer]

Hi Mumps1,

the search word column contains typical words that would be used to search for and find the information in column A. Yes , someone will search with a single or multiple words.


example: a person search with the word "induction"


then it needs to look in column C for a match , if it finds a match or several matches it must then show all the rows with all the information in the rows as results.


Search word Induction will find a match in column C (row 14,24, 222,223,224 etc) then it must show the results with the matching rows information from column A,B,D .
HL Induction Introduction.pdf Self-study guide Nedbank Retail Business Banking
HL Induction Digital.pdf Nedbank Retail Business Banking
BB Induction Bulls eye chart.pdf Power Point Presentation Nedbank Retail Business Banking
BB Induction Client Experience group activity.pdf Booklet Nedbank Retail Business Banking
BB Induction LC Client Review Manual v14.pdf Booklet Nedbank Retail Business Banking
BB Induction Leadership Personas Handout.pdf Hand-Out Nedbank Retail Business Banking

etc
etc

Hope this explains a bit more .
Thank you for your help, much appreciated!

[sintek]

One way...

Please Login or Register  to view this content.

[Mumps1]

Try the attached file. In Sheet1, enter your search criteria in B1 and press the RETURN key.

[cfcoetzer]

Thank you that is awesome !

[cfcoetzer]

Thank you, it is what I was looking for

[sintek]

.........................
THANKS.gif

[Mumps1]

Glad to help.