Once again this copies the formula down all the rows, incrementally changing each one. Now select Cell F7 and drag the yellow handle down to row 4,506. The 5000can be 10000 or 100000, it doesn't really matter. You will need to change this if you decide to use a different cell for your search box. NOTE: The $B$5 refers to your search field. In Cell F7 enter the following formula and press return: This will copy the formula down all the rows, incrementally changing each one to refer to Cell B3, B4, etc. Now select Cell G7 and you will notice a yellow handle at bottom centre of the cell. NOTE: This formula is just telling Numbers to populate Cell G7 with whatever data is in Cell B2 in your Data sheet, since this is the first cell containing the data you want to be searchable. In Cell G7 enter the following formula and press return: The reason for this number is that we're allowing enough room below your search field for all of the corresponding rows of data you have. There is no need to touch your Data sheet.įirst make sure you have at least 4,506 rows available in your Search Sheet. The search results should appear below the search box.Īll steps in this answer need to be carried out on your Search sheet. The data being searched is located in Column B of the Data tab, from rows 2 to 4,500. I would like the search box to be in cell B5 of the Search tab. The 1st tab is called Search and the 2nd tab is called Data. These haven’t produced any results either way, so I think maybe what I want to do isn’t possible.Ĭan someone hear confirm either way? If possible, how do I achieve this? I’m sorry if this question seems like I haven’t shown any research efforts, but so far I’ve searched within Numbers Help, Apple’s Numbers support pages and done general Google searches. The data to be searched is also within the same Numbers document, but in a separate tab. The idea is that users could enter search terms in the box and it’d return any matching results, just like using a search engine.

I want to know if it’s possible to create a search box directly within my Numbers document without the use of scripting, automator or terminal.

What is the best search engine for mac